Re: Shell Variable to set EXPLAIN on

On 15 Sep 2005 09:05:33 -0700, goggleaccount@dodgeit.com < goggleaccount@dodgeit.com> wrote: > > We use a product on AIX box, which uses Informix IDS 9.4 as database. > We would like to enable EXPLAIN on for certain users for the whole > session. Is there an Unix shell variable which when set thru .profile, > can capture the information about all SQLs that ran from that Unix > Session. No, I don't think there is such an environment variable. Consider whether you have sqliprint and can use it. You can use 'onmode' to set explain on after a session is started; that isn't quite what you want, though. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ sending to informix-list