Re: How to get release

On Thu, 7 Jul 1994, Jack Parker wrote: } } 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. **** Yes and no (I think). We are running 4.10 tools against 5.00 engines : $INFORMIXDIR/bin/isql -v INFORMIX-SQL Version 4.10.UD2 Software Serial Number AAA#C158647 $INFORMIXDIR/lib/sqlexec -V INFORMIX-SQL Version 5.00.UC2 Thu May 7 17:13:52 PDT 1992 Software Serial Number AAA#C158646 and $INFORMIXDIR/lib/sqlturbo -V INFORMIX-OnLine Version 5.00.UC2 Thu May 7 17:14:31 PDT 1992 Software Serial Number AAA#C158649 So for the standard engine report, the version number is correct. I think that the "INFORMIX-SQL" is a red-herring. Anybody know any better. Confused? I am. } } } > 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. } _____________________________________________________________________________ } } ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Mark Lansley <mark@dsl.com> | "Whoa!....Maybe I'll just pass Druid Systems Ltd, UK | on my usual barking frenzy." +44 932 571212 (Vce) 571552 (Fax) | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~