Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.