Search results for query: *

Hi, In my cross-platform development with ADO I have constructed the following kind of statement for SYBASE and MSSQL: IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.table_name') AND name='index_name') BEGIN DROP INDEX table_name.index_name ... END How would I go about to...

I get an error (255 - not in transaction) on this procedure. Yet I can't seem to cure it with begin work/commit work. Perhaps I'm just inept. It only fails when the "where current of" is there in the update. If I don't use "current of" it works, but then I need to use a more...

Where do I find OLEDB for 11.9.2? (On 12.5 it's on the CDs right?) Thanks in advance, AoN

Does Informix have logical bit operators? &, |, ^ (AND, OR, XOR) I.e I want to calculate 5 & 4 = 4 What's the syntax - if it exists? Thanks in advance, Anders

Does ASE have a functionality like Informix/MSSQL's cast/convert beyond the oneway str function? Thanks in advance, AoN

I'm working on an application which will work against several DBMS's. I've found that if I use the MSSQL specific TOP n in one of my queries I cut time to a third. I've been looking for an equivalent that for INFORMIX. Basically it returns either the TOP n percent, or the TOP n rows. I need...

I'm working on an application which will work against several DBMS's. I've found that if I use the MSSQL specific TOP n in one of my queries I cut time to a third. I've been looking for an equivalent that for ASE. Basically it returns either the TOP n percent, or the TOP n rows. I need...

Hi, I'm new to sybase and want to restore a sybase 10 DB in sybase 11. Could someone please guide me through this like if I was a four-year-old? (Or point me to a doc that does the same.) Currently I have backed up my the DB in question and moved it to the 11-server, but when I try to...