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-----------------