Sql statement to find Informix version

Hello all, Does anyone know if you can use a sql statement to get the version of the informix server that is running? Is it stored in a system table somewhere? I cannot locate it. Thanks in advance. David Tamburin david.tamburin@protegrity.com

david.tamburin wrote: > > Hello all, > > Does anyone know if you can use a sql statement to get the version of the > informix > server that is running? Is it stored in a system table somewhere? I cannot > locate it. You can try: SELECT owner FROM sysmaster:systables WHERE tabid = 99; This should work as the owner of table 99 (tabname: " VERSION") contains the version (minus the platform letter: U, T, F) that created the database and the creator of the SYSMASTER database is always the current version. Art S. Kagel

Hi select owner from systables where tabname = " VERSION" The select looks like that you need, but I'm not sure which version you will have. An server that created your database or current server. Eugene Nechayev In article <7d8ep6$aus$1@news.xmission.com>, <david.tamburin@protegrity.com> wrote: > > Hello all, > > Does anyone know if you can use a sql statement to get the version of the > informix > server that is running? Is it stored in a system table somewhere? I cannot > locate it. > Thanks in advance. > David Tamburin > david.tamburin@protegrity.com > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

In article <36F7F315.2F98@bloomberg.net>, kagel@bloomberg.net wrote: > david.tamburin wrote: > > > > Hello all, > > > > Does anyone know if you can use a sql statement to get the version of the > > informix > > server that is running? Is it stored in a system table somewhere? I cannot > > locate it. > You can try: > > SELECT owner FROM sysmaster:systables WHERE tabid = 99;> > This should work as the owner of table 99 (tabname: " VERSION") > contains the version (minus the platform letter: U, T, F) that created > the database and the creator of the SYSMASTER database is always the > current version. > > Art S. Kagel > Hello Do you really need to execute an SQL statement ??? If you have dbaccess/isql installed, you could just execute the command 'dbaccess -v' or 'isql -v'. This will show you the IDS version. Regards Paulo Roberto Marelli de Amorim TS&0 Consulting Brasil pauloamorim@uol.com.br -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own