Re: Getting Informix engine version info
->Date: Thu, 7 Jul 94 16:01:26 MDT
->From: george@talon.ftc.scs.ag.gov
->To: alan@po.den.mmc.com (Alan Popiel), informix-list@rmy.emory.edu,
-> john@gagme.wwa.com
->Subject: Re: Getting Informix engine version info
->
->Well, I tried the select tabname, owner from systables where
->tabname = 'version'. No rows selected. Turns out, that in
->SE version 5 systables.version is an integer. Furthermore, the
->enteries in this column, while they are all the same for tabid < 100
->(system tables) they are different (and unique) for every other table.
->
->Any further info is welcome.
->
->George Teachman
->USDA-SCS
Please don't confuse the column systables.version with the version of
the engine or database. Systables.version is incremented when you
UPDATE STATISTICS for a table, maybe at other times as well.
I think that I remember the engine/DB version being stored as a character
string in the owner column. As Mike A. pointed out, tabname = " VERSION",
not "version" as I misremembered. Note the leading space, and that
"version" is a valid table name.
Regards,
Alan ___________________________
______________________| R. Alan Popiel |__________________________
\\ Internet: | Martin Marietta, SLS | /
\\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. /
)Voice: | Denver, CO 80201-0179 USA | (
/ 303-977-9998 |___________________________| (But you knew that!) \\
/________________________) (____________________________\\