Re: SET EXPLAIN (Msg File Prob)

anand@sin-co.sin-ro.DHL.COM (Chetan anand) writes: >Can any one pull me out of dark about why do I get error -581 when >I use 'SET EXPLAIN ON'. The error explantion is >-581 Error loading message file. > >This SET EXPLAIN statement could not be completed because the database >server was unable to find the file of message templates it uses when >preparing explanatory output. Consult with the person who installed the >Informix software. This is symptomatic of having installed the Informix products in the incorrect order. Re-install the products in the following order (you don't have to re-initialize your database, just re-install the products): - Tools products in ascending order of version number; - Engine products; - Connectivity products. ___ ___ Senior Consultant / ) __ . __/ /_ ) _ _ __ Informix Software Inc. (303) 850-0210 _/__/ (_(_ (/ / (_(_ _/__) (-' ~/ '(_- 5299 DTC Blvd #740 Englewood CO 80111