Re:SQL EXPLAIN Error

Posted in 1996

Jeff Craig — 12 Aug 1996 09:33:09 -0400 — source: Informix-list mailing list archive (1991-1998)

Please note that there is a bug with the SET EXPLAIN command when using UNIX Korn shell. The bug causes the following two errors: 534: Cannot open EXPLAIN output file. 134: ISAM error: no more locks This bug affects: Silicon Graphics Challenge XL running IRIX 5.3 Online DSA 7.12.uc3 Informix-recommended work-around is to set SHELL environmental variable to /bin/csh, that is, use the cshell. Thank you to those of you who responded to my plea for help. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------