Re: Determining version dynamically

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? > Thanks, > Paul select owner from systables where tabid = 99 (or where tabname = " VERSION") Dragan Jurkovic MRRM (Canada) Inc.

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? > > Thanks, > > Paul > > select owner > from systables > where tabid = 99> > (or where tabname = " VERSION") That will only tell you what version created that database. 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. Art S. Kagel