Recent content by KarthikBabu

Hi, What is the Sybase equivalent of Oracle snapshot? Can snapshots be created in Sybase. What about views? Thanks!

We have quite a unique requirement. We are running Sybase 12.5.03 on HP 1280 (Compaq Tru 64 5.1B). We have this monster table (name it Table_A) that stores the transaction information of different user accounts. The table is HUGE - stores 450 Million records and has a Clustered Index on...

In T-SQL, Is there a way to find out the number of rows affected by an insert query? I have the following statement. Insert into #temp_table select (....) Now, without using 'select count(*) from #temp_table', is there any way (or system function) by which i can find out the number of rows...

Thanks. That helps a lot !!

We have two Sybase 12.0 servers, say ServerA and ServerB. Every morning, we take a dump of ServerA and load it to ServerB. Will running DBCC on ServerB be sufficient enough to check the consistency of the databases of ServerA ? fyi - Both the servers are identical to each other in terms of...

Thank you.

Recently we upgraded our Compaq Dec alpha from Tru64 4.0.1 to 5.1. We are getting the following error when we try to run a 3rd party vendor supplied executable. ERROR_MESSAGE_RPT.EXE: /sbin/loader: Fatal Error: object libcurses.so from liblist in ERROR_MESSAGE_RPT.EXE has version...

Are there any generic guidelines on when to do a "Re-org" on a given table/index. Any pointers will be highly appreciated.

Michelle, I believe what you are doing in the shell script is perfectly fine. But I think some set up needs to be done at the Mail Server. In my previous company, we were using this feature and the shell script had the following command - echo "Error in program" | mail...

You may use &quot;isql&quot; with the &quot;-s&quot; option. The &quot;-s&quot; option defines the column separator. Use tab character as a column separator. isql -U<username> -s&quot;<EnterTabHere>&quot; Hope this helps you.

Steve, i think your requirement is to capture the value returned by the SP sp_testc into the variable @a. If so, please try exec @a = sp_testc go Hope this solves your problem.

Thanks Greg. That is an wonderful idea. Today we have implemented security using the .sqlpw file and feeding the contents at the appropriate time. But some developers have broken the security by copying the logic that is built to read the contents of the .sqlpw file. (We use a C executable to...

Is there anyway by which i can prevent the value of an environmental variable from being displayed while using the echo statement. I have an environmental variable SQLPASSWORD that i am setting up in my .profile. I do not want the value of this variable to be displayed while using the echo...

You may use the &quot;find&quot; command for this. find <DirectoryName> -name '*' -mtime +7 -exec rm -f {} \; Please read the manual pages of the &quot;find&quot; command before you use this.

Thanks. Yeah, i can change my shell script into a C executable and use the setuid bit. Thanks for your help, deehowe.