Re: SQL Explain from a client?

Dear Dirk, 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. Regards, Jason 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? > >Thanks, >Dirk Fromhein >df@watershed.com >http://www.watershed.com Jason Harris Informix DBA Westpac Banking Corporation NOTE: I add all these address at the bottom of people who spam me Now when their extractors extract my e-mail address they will also end up spamming each other. wtcjr@ix.netcom.com Shevsky@hotmail.com speech@speechrecognition.com SmartBiz@NevWest.com slender@juice4u.net sbliss@earthfriends.com ron@moneyaction.com removeme@gwh.net rocco@lostvegas.com market@DRAWBRIDGE.NET Foxyrusski@mail-response.com emaster@email-man.com waynesmail@earthlink.net