Search results for query: *

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

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

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

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

Use the strtod function defined in the stdlib.h

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