Search results for query: *

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

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

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.

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

I have a shell script that needs "execute only" permission to group and others for security reasons. I have defined the permission code of the script as 711 (owner rwx, group execute, others execute). But the members of the group are unable to run the script, the script just hangs...

Is Partial BCP possible? My requirement is to migrate a part of the data in a table from one server to another. Say, data belonging to a particular department. Can BCP be used for this purpose? If so, how ? Please note: I cannot use the "-F" and "-L" options as the data...