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

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

Does the Fetch operation return the no of rows matching the select criteria or only the number of rows buffered in this operation which could be less then the number of rows that acutally match the select criteria?

Hi Is this code correct. main() { char *p; p = &quot;This is what is assigned first&quot;; printf(&quot;%s\n&quot;, p); p = &quot;This is second string&quot;; printf(&quot;%s\n&quot;, p); } This piece of code works fine. What I want to know is this acceptable?? Where are the literal...

Hi I was trying to modify my .profile, which based on whether I am using a KEA or a Exceed terminal would set some of my environment variables differently. How can my .profile know which terminal has been invoked ? thanks

Hi I am trying to read a DAT tape using the dd command on Hp-Ux 11. I wanted to know the return values for this command I have gone though the man pages and have found that if there is an error it returns >0 else 0. What are the different return values for different error conditions. like end...

Hi How can we set the environment for the cron jobs? The cron daemon spawns a shell (in which the cron job executes) with the same user permissions as the one who made the cron entries but doesn't take his environment settings provided in the .profile. thanks!

Hi I am using HP-UX 10.20. I have made some entries in the cron file using the crontab -e. the entry is not getting scheduled. Am I doing somthing wrong ? Apart from having an entry in cron.allow is there some other prerequisite for cron ? thanks!