RE: How get Informix db server version through a SQL command?

Posted in 2000

Yarlagadda, Ravi — Mon, 13 Nov 2000 14:38:22 -0500 — source: Informix-list mailing list archive (1991-1998)

The following SQL query provides to find out the IDS version. select * from systables where tabname = ' VERSION' Owner field contained IDS version. ----- Ravi Yarlagadda -----Original Message----- From: Fabrice Lemay [mailto:"fabrice_lemay[NOSPAM]"@hotmail.com] Sent: Monday, November 13, 2000 11:07 AM To: informix-list@iiug.org Subject: How get Informix db server version through a SQL command? Hi, Starting in using Informix db, I would like to know if there's a SQL command which allow to get the db version? Such command exist using Adaptive Server Anywhere from Sybase; it is : "select @@version" Is there an equivalent with Informix? Regards, -- Fabrice (to reply, please remove the [NOSPAM] in my e-mail address)