Re: SQL-trace

Posted in 1998

James Richardson — Thu, 12 Nov 1998 15:59:52 -0000 — source: Informix-list mailing list archive (1991-1998)

You can try setting the environment variable SQLEXPLAIN to "ON", this (may! devpends on your server, I suppose), create a file called sqexplain,out in the current working directory. Don't forget to unset the variable and restart the program after the program starts though. If you want to do this from indise a program then you can just use SET EXPLAIN ON; Cheers James Andre Naegele wrote in message <36495C14.6FB00C06@alcatel.de>... >Hello, > >how can I trace (record) the "Start-up" of an application >(Billingsystem) >with an informix Online Dyn. 7.2 Database in the background. > >Is it possible with an SQL script ? > >Best regards >A.N'gele >