Re: Product Version and SYSTABLES version value

Cheryl Kendricks wrote: > > Does someone know the connection between the Informix Engine's Version > Number on the media received, the ".snfile" file or dbaccess -V command > verse the value contained in the row in the ' VERSION' systables? > If you do PLEASE EXPLAIN? Not in great detail, but here goes. I didn't think there WAS a version number in $INFORMIXDIR/etc/.snfile, just the product name and serial number. dbaccess -V will give you the engine version number, which should match thaton the box. The VERSION field in systables is set when the database is created. I think this is also set when major changes occur during an upgrade (generally the first time the database is opened), but I could be wrong here. Certainly it is possible to have an older version in this field than the current engine running. Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+