Re: SET EXPLAIN: Need Help NOW!

Ginger B. Pisik wrote: > > Can someone please help me. > > We have several developers all running code in the same directory > with the SET EXPLAIN ON option set. The output is going to > "sqexplain.out". Because we are all writing to the file, it is > VERY difficult to analyze the "sqexplain.out" file. > > Does anyone know of a way to change where the EXPLAIN output > goes to? If so, please E-Mail me. THanks!!! > > Doug Pisik > Sr Systems Engineer > Home Depot > dsp01@homedepot.com The really annoying problem is when you turn explain on in a client program which talks to the host via I-Net/I-Star (or DSA); then where does sqexplain.out go? I think $INFORMIXDIR or /tmp, but I can't remember. Certainly changing your directory on the client machine won't help. A neat enhancement would be 'SET EXPLAIN ON filename'. Oh well. -- __\\/__ / ^ ^ \\ (\\| (o)(o) |/) ------------------------oOOOo--oo--oOOOo---------------------------- | James Bennett | | Internet: james@bi-tech.com| | Bi-Tech Software, Inc | | Telephone: 916.891.5281 | | Chico, CA 95973 | | FAX: 916.891.5011 | -------------------------------------------------------------------- | There are two rules for success in life: | | Rule 1: Don't tell people everything you know | -----------------------------------Oooo.---------------------------- .oooO ( ) ( ) ) / \\ ( (_/ \\_)