Re: help: set explain on

Malcolm Weallans wrote: > saipoh wrote: > > HI, > > > > I am on informix SQL 4.11 and am trying to set explain on. > > I've been getting error msg 581(error loading message file) > > Does anyone know what message file?? > > > I have seen this problem a few times. It normally comes about when an > earlier version has been copied into /bin rather than $INFORMIXDIR/bin. > When the software is correctly installed there is no problem, but when a > subsequent update is made it can lead to problems similar to your > experience. > To check this change your PATH so that $INFORMIXDIR/bin precedes /bin. > > If that is the case to remedy the problem you will need to delete a large > number of unwanted files from /bin, /etc, and many other directories. > > There is a possible alternative cause. If the software was installed in > the wrong order. The products should always be installed Tools, Engines, > Networks (or TEN for short). If you haven't installed the products in > this order merely re-install in the correct order. That's all true. But I beleive there was a bug of this nature in the early version 5.00.xx release of the engines. What is the version of the engine? Cheers, -- 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! | +------------------------+------------------------------------------------+