Oninit cdi / Archive
Talk to an expert →

Hey Informix - Who Are You?

Posted in 2004

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

Hillel Eilat — — source: Usenet: comp.databases.informix

Hey Informix - Who Are You? When in ESQL - how can I determine at run time what is the version with which I am working - i.e - 7.2 , 9.1 and alike... Thanx. /H

↪ replying to Hillel Eilat
Doug Lawry — — source: Usenet: comp.databases.informix

This works for version 9.x: SELECT DBINFO('version', 'server-type'), DBINFO('version', 'major'), DBINFO('version', 'minor') FROM systables WHERE tabid = 1 See IBM Informix Guide to SQL Syntax / Segments / Expressions. -- Regards, Doug Lawry www.douglawry.webhop.org "Hillel Eilat" <hillel@attunity.co.il> wrote in message news:chi1kv$pkf$1@news2.netvision.net.il... > > Hey Informix - Who Are You? > > When in ESQL - how can I determine at run time what is the version > with which I am working - i.e - 7.2 , 9.1 and alike... > > Thanx. > > /H

↪ replying to Hillel Eilat
Art S. Kagel — — source: Usenet: comp.databases.informix

On Mon, 06 Sep 2004 12:01:48 -0400, Hillel Eilat wrote: The engine version or the ESQL/C version? Art S. Kagel > Hey Informix - Who Are You? > > When in ESQL - how can I determine at run time what is the version with > which I am working - i.e - 7.2 , 9.1 and alike... > > Thanx. > > /H

Related threads

Glossary