Re: Getting Informix engine version info

On Thu, 7 Jul 1994, Alan Popiel wrote: } ->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, Stuff left out } } Regards, } Alan ___________________________ } ______________________| R. Alan Popiel |__________________________ On line 5.01 carries an entry in systables for tabid 99 and tabname " VERSION" --that is a blank before capital VERSION and 5.01 is in the "owner" column. -- Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523; 303-491-1244 FAX 303-491-4414 cwoodall@vth1.vth.colostate.edu You can do anything with a computer, but you might not want to. --