Re: Getting Informix engine version info
->john@gagme.wwa.com (John T. Fontanilla) writes:
->
... lots of other stuff deleted ...
->
-> How does one know the SE version?
->
-> Please e-mail. Thanks!
->
->John
My thanks to Mark Lansley <mark@dsl.com> for telling about:
$INFORMIXDIR/lib/sqlexec -V
This was something I didn't know about.
However, there is another way as well. Starting with some 4.x version,
the data dictionary table 'systables' contains a dummy entry for 'version'.
I don't have access to any of my newer version databases at the moment,
(insert whine about using 2.10.03K database here) so I am working from
memory and you might need to adjust this slightly:
select tabname, owner { owner?? contains version number }
from systables
where tabname = 'version'; { or 'Version' ??? }
{ You can also try where tabid < 100. }
Again working from memory, I recall using this in 4.x and 5.x databases,
both SE and OnLine. I don't know whether this feature has been continued
in versions 6.x and 7.x.
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!) \\
/________________________) (____________________________\\