Re: Spooling all SQL Statements

If you have informix 7.X, than you can give a look at the "auditing" feature, but it affects the performances. Cheers. Valery Fouques valou@hotmail.com SYSADM GOSPORT-FRANCE /\\oO/\\ _ __/| \\`O.o' "355/113 -- Not the famous irrational =(_ _)= number PI, but an incredible simulation!" U Lou Person <lperson@mcny.com> wrote in article <5ko05e$p9k@cssun.mathcs.emory.edu>... > Thanks for your reply. set explain on is done at the application > level. I want to accomplish the same thing on the server level, > independent of setting "set explain on" before the query > is executed. > > > -----Original Message----- > From: Marco Greco [SMTP:marcog@ctonline.it] > Sent: Tuesday, May 06, 1997 2:38 PM > To: informix-list@rmy.emory.edu; Lou Person > Subject: RE: Spooling all SQL Statements > > Yes. use "set explain on" to start logging queries to file sqexplain.out, > "set explain off" to stop logging. > Note that if sqexplain.out already exists in your current path, queries will be > appended to it, so watch that different applications that do a set explain on > are run from different paths, or all you get is chaos > > HTH, > Marco > ____________________________________________________________________________ > Marco Greco <marcog@ctonline.it> rem radioterapia 39 95 447828 fax 446558 > Informix-FAQ http://www.iiug.org 4glWorks http://www.ctonline.it/~marcog > > --- On 6 May 1997 00:11:14 GMT Lou Person <lperson@mcny.com> wrote: > > We are sending sql statements to OWS from an > application. Is there anyway to "spool" all sql > statements which are sent to the server? Meaning, > can we store all SQL statements, which OWS > executed, to a table (or file) for subsequent review? > > Thanks, > > Lou Person > lperson@mcny.com > > > -----------------End of Original Message----------------- > > > > > >