RE: Program finding out what the engine is

Just check sqlca.sqlawarn after opening a database. That tells you lots. And it's all in the Informix-4GL manuals. It's even in Cathy Kipp's book - which is lucky for you as I have a copy of that at home (I'm really sad!). If you look at SQLAWARN[4] it is set to W if the database statement selected an Informix-Online database. Regards Malcolm -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of 5 Cats Sent: 22 January 2005 14:07 To: informix-list@iiug.org Subject: Program finding out what the engine is I'm looking for a neat way for a program in 4GL (e.g. running on the Unix box) to tell if the database it's connected to is SE or IDS - that could be IDS 7.3, 93. or 9.4. We have a method from ages back to do with what binaries are in $INFORMIXDIR but I don't like that. It could look for a specific system catalogue or column in a system catalogue that is only present in IDS, or.... TIA :) 5 cats sending to informix-list