HOW TO retrieve INFORMIX Version from SQL.

Posted in 2000

Laurent REVEL — Thu, 23 Nov 2000 14:20:39 +0000 — source: Informix-list mailing list archive (1991-1998)

R&D Question for my developper : Like I m working with INFORMIX 9.20.UC2 + EXCALIBUR DataBlade 1.30.UC2 we would like to get the INFORMIX Version from the simple SELECT. I searched inside the SYSTABLE and did : select * from systables where tabid = 99 but the result is not accurate : VERSION 9.20D5 0 99 0 0 0 0 10/26/2000 0 0 0 0 0 0 0 like we are working on 9.20.UC2 and not 9.20D5. Any idea will be welcome. THANKS ----- REVEL Laurent / DBA Engineer ----- REEF - 116, rue du Faubourg St Martin - 75010 PARIS Office Tel: 33 (0)1-55-26-53-53 and ask : 5404

↪ replying to Laurent REVEL

smooth1 — Thu, 23 Nov 2000 19:28:55 -0000 — source: Informix-list mailing list archive (1991-1998)

Check the latest version of the FAQ at www.smooth1.demon.co.uk I've just added this info! Laurent REVEL wrote in message <3A1D27B7.689C35CF@reef.com>... >R&D Question for my developper : > > Like I m working with INFORMIX 9.20.UC2 + EXCALIBUR DataBlade 1.30.UC2 >we would like to get the INFORMIX Version from the simple SELECT. > > I searched inside the SYSTABLE and did : > > select * from systables where tabid = 99> > but the result is not accurate : > > VERSION 9.20D5 0 99 0 0 0 0 10/26/2000 0 0 0 0 0 0 0 > > like we are working on 9.20.UC2 and not 9.20D5. > > Any idea will be welcome. > > THANKS > >----- REVEL Laurent / DBA Engineer ----- >REEF - 116, rue du Faubourg St Martin - 75010 PARIS >Office Tel: 33 (0)1-55-26-53-53 and ask : 5404