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/