Search results for query: *

olded: I just want to be able to write a statement so I can execuse it and it drops the index if it exists. Wether I do it via dbaccess, ADO, embeddedsql or what not doesn't matter. Now, I realise it might not be possible to do it the way I want it, and then I'll settle to use a recordset to...

I was vague in my problem specification, sorry. How do I get a query execute something, say a drop index, IF the index exists in a 'simple' query? Is it possible, or do I need to work it through a cursor? Thanks, Anders

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

Oh, I forgot to mension I need to use this function in a subquery.

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

Is it possible to do this for SYBASE 10.x or 11.x? Thanks.