Re: Looking for Version in System Tables
Posted in 1996
The version stored there will be the last MAJOR release change, not necessarily
the exact current version
---------------------- Forwarded by Kate Tomchik/IS/SSC/THD on 10/28/96 10:34 AM
---------------------------
pdutta @ airmail.net (Partha Dutta)
10/24/96 05:24 AM
To: informix-list @ rmy.emory.edu @ INTERNET
cc: (bcc: Kate Tomchik/IS/SSC/THD)
Subject: Re: Looking for Version in System Tables
PairOShoes wrote:
>
> Is the version string ('Online Dynamic Server 7.12.UC1') stored in any of
> the system tables? If so, where?
>
> Thanks,
>
> Lee
I don't believe that string is stored in the system tables. The closest
possibility is the version number, which can be found in systables:
select *
from systables
where tabid = 99;
I think the owner field will have the version of the engine.
Partha Dutta
pdutta@airmail.net