Re: -534 Cant Open Explain File

root@132,197.248.9 (Workstation Administrator) wrote: >I'm scratching my head on this one. > >In an attempt to set explain on in a query, I am returned a -534: >Cannot open EXPLAIN output file error. I'm running the query in my home >directory and have verified that permissions are ok. > >Any ideas? > >Thanks. > I see two possible causes: 1. Even though you run the query in your home directory, the Informix engine (sqlexec, sqlturbo or the On-Line thread) is running on a different machine. Check the permissions on that machine since the sqlexplain.out will be created there. 2. I have seen error -534 when the Informix products were not installed in the proper order. Make sure the engine/connectivity tools are installed last. Follow installation instructions. Also, it always helps to identify the Tools & Engine version and configuration when posting questions. Catalin -- ========================================================================= Catalin Badea _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/ _/ _/_/_/ _/ _/ _/ _/ _/_/ _/ Senior Technical Architect _/ _/_/ _/ _/_/_/ _/ _/_/_/ _/ _/ _/ _/ _/ _/ Tecsys Inc. _/ _/_/_/ _/_/_/ _/_/_/ _/ _/_/_/ ===== cat@tecsys.com =========== include system "disclaimer.4gh" ===== == http://www.virtualmarketplace.com/LEVEL3/ITEC/TECSYSE/TECSYSE.HP ===