Re: Getting Informix engine version info

From Alan Popiel: << STUFF DELETED >> * 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. The exact syntax is: select owner { owner contains version number } from systables where tabname = ' VERSION'; This works except for the VERSION doesn't include the extension of the version. In 4.10.UC2, the UC2 is missing, so systables.owner returns 4.10. It gets you close, though. Robert Minter |Data Systems Support| \\\\\\_/// Programmer, Software Development | Orange, CA | ( _ _ ) internet: rob@dssmktg.com | Tel: 714.771.0454 | (| ^ |) bangpath: uunet.uu.net!dssmktg!rob| Fax: 714.771.3028 | \\`-'/ #include <disclaimer.h> SURF'S UP \\_/