Re: Getting Informix engine version info

->> 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. } -> ->This works for me using ' VERSION' -- All caps with a blank space in ->front using ONLINE 5.**. I didn't know about this either, might come ->in handy. ->This will work for some things but in most cases one also needs its ->added extention. -> ->-- ->Mikea Mike, Thanks for the confirmation. When you think about it, " VERSION" with space and caps makes sense, because "version" would be a valid table name. Was the version number returned in the "owner" column? How did the value returned compare to the info returned by "sqlexec -V"? Did you find any useful info in any of the other columns of systables? I don't recall being able to find anything that said whether the engine/database was SE or OnLine. This kind of ID info might be useful to include in reports, *especially* in organizations that run the same or similar software against multiple databases, not all of which are at the same release level. 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!) \\ /________________________) (____________________________\\