Recent content by nkm

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

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

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

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; >>...

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

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

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

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

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

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

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

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

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

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

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...