Re: help: set explain on

> > 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?? > > Pls help > > > thanks, > saipoh > > > 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. > > saipoh@hpmitd27.mal.hp.com Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc