Re: How to get release

Alan just asked me to verify against an Online engine. Guess what? sqlturbo -V and cat $INFORMIXDIR/etc/OnLine-cr both return the proper value. Systables is incorrect, sqlexec -V reports the ISQL version. } > select * from systables } > where tabname = " VERSION" { space and caps important } } } tabname VERSION } owner 5.01 } tabid 99 } created 10/21/1993 # zero/null fields not shown } } $INFORMIXDIR/lib/sqlexec -V } INFORMIX-SQL Version 5.00.UC2 Tue Apr 7 10:43:51 PDT 1992 } ^^^!!! } } $INFORMIXDIR/lib/sqlturbo -V } INFORMIX-OnLine Version 5.00.UC1 Thu Jan 9 17:49:12 PST 1992 } } cat $INFORMIXDIR/etc/OnLine-cr (white space added for readability) } INFORMIX-OnLine Version 5.00.UC1 } } As you can see... Our DBA installed 5.01 and then de-installed it and missed } cleaning up systables. Interesting. } j. _____________________________________________________________________________ Jack Parker | "A lawyer is a learned gentleman Hewlett Packard, BSMC Boise, Idaho, USA| who rescues your estate from your jparker@hpbs3645.boi.hp.com | enemies and keeps it for himself." (208) 396-5388 (W) (208) 384-1623 (H) | -Henry Broughman _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________