How can i write a log query sequence?

Hi at all! I need to write in a text file all the query that Informix applied in a database. I can do that?...and how? Tnx at all!

Pablo wrote: > I need to write in a text file all the query that Informix applied in > a database. I can do that?...and how? There aren't any simple ways to do that. You could consider using I-Spy to do the monitoring - it would work. ON-Audit does not help. ON-Log does not help. Nominally, you could use SQLIDEBUG and sqlprint; it would include lots of data too, which would inflate the volume of logging. Nominally, you could force SET EXPLAIN ON for all sessions - not easy and very verbose. If your system doesn't work too hard, you could consider using onstat, but it would not reliably pick up short-duration statements. Is this something you want to do for a short time, or a permanent logging for auditing purposes? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/