Re: Spooling all SQL Statements

Lou Person 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? set explain on; ? Or something like a batch? INFORMIX, hint, hint .... What about a new onconfig(or env) parameter: EXPLAINLOWCOST = just write to sqexplain.out if the estimated cost is beyond. So we could have explain mode turned on, but just see the hogs. -- Chris Drauch <cdr@xteam.co.at> ... just speaking for myself ...