Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nkm
  • Order by date
  1. nkm

    Is commit tran a blocking call

    Hi Just wanted to know if a commit tran is a blocking call i.e. it will wait until a physical write happens. Also if someone can suggest any good link/article where I can know the logging mechanism in Sybase. thanks
  2. nkm

    Formatting money

    Hi I wanted to format the a float value as 68764.2342 with comma separators and 1 decimal point
  3. nkm

    multiline at command

    Hi If I put the checking stmts into a file and invoke it it works fine. I am wondering the shell that at spawns while executing this stmts is not sh. How can I check what shell is getting spawned
  4. nkm

    multiline at command

    Hi I am trying to execute this at now + 1 minute <<! echo &quot;hello&quot; >> /home/krishre/testat.out echo &quot;there&quot; >> /home/krishre/testat.out if [ $? -eq 0 ]; then echo &quot;Its successfull&quot; >> /home/krishre/testat.out else echo &quot;It failed&quot; >>...
  5. nkm

    Selecting from a table dynamically

    Hi The version given using select @@version is Adaptive Server Enterprise/11.5.1 regards
  6. nkm

    Selecting from a table dynamically

    Hi I tried the exec command but it comes back saying The name <SQL> is not a valid identifier. I guess exec expects a stored procedure. How do I overcome this ... thanks
  7. nkm

    Selecting from a table dynamically

    Hi Can we do this declare @tabName char(30) select @tabName=&quot;CreditUser&quot; select * from @tabName I want the table name to be determined at run time If not what is the alternative regards
  8. nkm

    Batch Delete

    Can we delete rows in batches from a table until all rows with the particular condition are deleted. e.g. Delete first 10 from <tab1> where ... thanks
  9. nkm

    Data transformation

    Hi I have a table which returns column values as AP, NAP, N/A But when the user views it I want AP to be transformed to Approved, NAP to Not Approved N/A to Pending. How can I write this in the select query itself. thanks
  10. nkm

    Convert function

    Hi Is there any way by which we can convert date to the format Mon-yy. The standard styles provided with convert function do not support this. I have to do this in a stored procedure. thanks
  11. nkm

    Altering column size

    How can I alter the column size for an existing table and not loose any data in it. thanks
  12. nkm

    set -o vi

    Hi If I set the output mode then the esc key which used to give me the directory contents based on the pattern stops working. How can I make it to work along with the output set to vi thanks
  13. nkm

    Delimiter problem

    Hi This is a simple programming issue. I need to delimit character patterns( any kind of ascii char is possible) in my output file. How can I use any other character as delimiter as it too could be part of the text. thanks
  14. nkm

    terminal io

    Hi Thanks ... Now all I need is a program to replay that script
  15. nkm

    terminal io

    Hi Can anyone give me some sample code to read terminal io. Actually what I want to do is to have a process in the background which would record all user pressed keys. Includes all commands executed, and text typed if an editor is opened. thanks...
  16. nkm

    Automate 4GL testing

    Hi Guys I am looking at how to automate the testing for Informix 4GL applications. The automation of C Code was fairly easy using TCL and expect. Can anyone point me in the right direction thanks
  17. nkm

    SQLCODE 244 ISAM Code 143 Urgent Help

    Hi Guys Thanks for the suggestions. I went through the code and I did find a deadlock in the code. Just an extract of what was happening in the code. The steps that were happening in my process were Steps PA1 (Process 1) PA2(Process 2) 1 Insert (T1) Insert (T1) 2 Insert (T2)...
  18. nkm

    SQLCODE 244 ISAM Code 143 Urgent Help

    Hi I have two processes running with do some inserts into a database. The inserts are in a transaction (Monitered by Encina). The first process tries to update the table while the first process is in the transaction. This results in SQLCODE 244 ISAM Code 143. I have tried giving lock mode...
  19. nkm

    Need suggestion to put error handler.

    Use the strtod function defined in the stdlib.h
  20. nkm

    Hi Can we write a SQL which give

    Hi Can we write a SQL which gives the sum of the counts of 2 individual tables combined with a union clause Basically select count(*) from tmp union all select count(*) from tmp1 This will return 2 rows I want the sum of the values of the two rows. regards

Part and Inventory Search

Back
Top