Re: set explain and ODBC (CLI)
Posted in 1998
On Mon, 04 May 1998 11:38:24 +0200, Helmut Leininger <Helmut.Leininger@bull.net> wrote: >Hi, > >I am using Informix connect and ODBC together with Informix ROM or other >tools for ad hoc SQL from a PC (Windows 95, Windows NT) to an Informix >Online database on the AIX server. If I issue a "set explain on", the >file sqexplain.out is created on the AIX server. Is there any way to get >this file created locally on the PC ? The explain output is by nature generated by the server so it has to write it to some location it has access to. The only thing I could think of is to set up some file sharing from the AIX server to the PC. How to get the server to write to such a directory is another question, and I have a fealing it would be hard if at all possible. Setting up file sharing the other way is easy however (Samba is one solution) so you could access the file from the PC easily. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)