Re: SET EXPLAIN ON

On Thu, 11 Sep 1997, Henning Stemper wrote: } in SQL and 4GL the SET EXPLAIN ON statement may be used } to obtain a measure of the work involved in performing } a query. } } Unfortunately this statement in our implementation is } leading to the error code 581, which says that there } in an error in loading a message file, which in turn } seems to point at an unsufficient implementation. } } Now my questions to the audience: } } 1. Where should the message file be located? } (my guess: $INFORMIXDIR/msg) Assuming you're using a non-GLS product (which ISQL and I4GL both are) then that's right. } 2. What should the name of the message file be? Error code -581 is found in the file sql.iem. However, the problem may be with one of the other engines-supplied files. Most probably, you broke the rule of TEN -- tools, engines, networks -- and installed an upgrade of the tools over the engines, thus overwriting the message file with SET EXPLAIN information in it with an older version. Either reinstall the engines over the tools, or extract the message files from the engines tape and copy/move them over the ones in $INFORMIXDIR/msg. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>