Re: SQL Explain from a client?

Jason Harris wrote: > Look in sysmaster in the syssqexplain table. You can get records from > their using your session id. I am not sure if this helps or if the > data will expire before you can get it. Its worth a try though. > On Thu, 16 Oct 1997 22:13:41 -0400, Dirk Fromhein > <Dirk.Fromhein@watershed.com> wrote: > > >Is there any way to access an explain from a client? > > > >As far as I know when Explain it turned on all the explains are > >interleaved for all queries in a file on the server. It seems that > >there is a way in 8.x to set the directory for where this file should be > >written on a per-session basis. > > > >Well what if the end user is accessing the database via JDBC or ODBC? > >How can I access the explain? It seems like a major problem... Sybase > >returns the explain text as a warning message so I can grab it on the > >client, Oracle is even better and I can pipe the explain into a table > >and just grab it... what can I do with Informix? The sqexplain.out file is created on the server machine in the user's home directory there. You can ftp from the client and retrieve it. You could probably write a stored procedure to print its contents with a little thought I've never tried. Art S. Kagel