Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.