Re: Determining version dynamically

OK I have several 7.24 servers that were upgraded in-place from 7.23 or 7.21 and the VERSION records still show 7.21UC1. However, I just checked the only in-place upgrade I have from 7.24 to 7.31 and that one DOES show 7.31UC2 with a create date of the date of the upgrade in May while the other catalog tables still show the original create dates last year! So either the 7.2x series did not modify this record or it is only modified if there is a change to the table or index structures or something. ---- Original Msg from: Jonathan Leffler <jleffler@EARTHLINK.NET> At: 8/10 22: Art S. Kagel wrote: > Dragan Jurkovic wrote: > > Paul Dembry wrote: > > > How can I determine the Informix engine version dynamically, > > > for example 7.1, 7.2, 7.3? Is there a hidden table somewhere > > > or perhaps a function I can call? > > > > select owner > > from systables > > where tabid = 99> > > > (or where tabname = " VERSION") > > That will only tell you what version created that database. Are you sure? I thought it told you the most recent version of the server that was different in some way. I agree it might not tell you the exact version of the current server, but it will be close. Sufficient to distinguish 7.1 from 7.2, etc. > So for this select to tell you what version the current server > is you would have to create a new database and perform the select > there. I guess this would work; painfully expensive with a 9.x database! -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>