Re: ESQL/C & $set explain on problem

Thanks to all who made suggestions. For those who are curious on the net here's the original question and the answer(s). ----------------------------------------------- > > > > > While I wait for Informix tech support to call me back, I thought that I > > would see if anyone on the net could help with this problem. > > > > In an ESQL/C program (ESQL version 4.10.UD2) running on an HP 9000/380, > > I am trying to do a '$set explain on' to watch the execution of the select > > statements following throughout the program. No errors come back, but I > > don't get a 'sqexplain.out' file anywhere that I can find either. > > > > Any suggestions? BTW, the program is talking to a standard engine (version > > 5.00.UC2) on another machine through I-NET. > * * * > > Maybe you have your $database statement after the $set explain statement, if > so try it before. > That's the problem in my case since the program changes databases in the course of running and I was looking for the query information about the second db. Also, per 2 suggestions I received, I found that Informix is writing the sqexplain.out file to my home directory on the server. IMHO, this is not a great idea since engine users are not required to have home directories on the server, but maybe it is the least of many potential evils. Thanks to all who responded to my question...I still have not been able to contact/received a call back from Informix tech support. Now I don't need to. Cheers, Kurt Andersen -- kurt@hpsdid.sdd.hp.com 619/592-4373 (voice); 619/592-8191 (FAX) 16399 W. Bernardo Dr. MS 61U65/San Diego, CA 92127 -----Standard disclaimer stuff applies for all of the standard reasons----- -- kurt@hpsdid.sdd.hp.com 619/592-4373 (voice); 619/592-8191 (FAX) 16399 W. Bernardo Dr. MS 61U65/San Diego, CA 92127 -----Standard disclaimer stuff applies for all of the standard reasons-----