Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: AoN
  • Order by date
  1. AoN

    If exists then do this and that....

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

    If exists then do this and that....

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

    If exists then do this and that....

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

    Foreach - where current of problem...

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

    OLEDB for 11.9.2

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

    Logical bit operations?

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

    Does convert/cast exist?

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

    MSSQL TOP n equivalent in ASE11.9.2 or later?

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

    MSSQL TOP n equivalent for Informix?

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

    MSSQL TOP n equivalent in ASE11.9.2 or later?

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

    SYBASE newbie restoring 10.x DB in 11.x

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

    Dynamic SQL

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

Part and Inventory Search

Back
Top