Re: The last executed SQL statement

Posted in 1999

have01@handelsbanken.se — Fri, 16 Apr 1999 15:04:43 -0400 — source: Informix-list mailing list archive (1991-1998)

Within the Stored Procedure : SET DEBUG FILE TO "foo.dbg"; TRACE ON; This will allow you to trace all the sql statements. If you require to monitor the statements try running "tail -f foo.dbg" HTH Harinath Venkata Svenska Handelsbanken New York.

↪ replying to have01@handelsbanken.se

a_nix@my-dejanews.com — Sat, 17 Apr 1999 09:11:43 GMT — source: Informix-list mailing list archive (1991-1998)

Thanks a lot for your Information. But I want to get triggering statement in a stored procedure used as triggered action and then store it in the database. Alexander Nikiforenko BelCAF, Minsk. Harinath Venkata In article <7f829t$g37$1@news.xmission.com>, have01@handelsbanken.se wrote: > > Within the Stored Procedure : > > SET DEBUG FILE TO "foo.dbg"; > TRACE ON; > > This will allow you to trace all the sql statements. If you require to monitor > the statements try running "tail -f foo.dbg" > > HTH > > Harinath Venkata > Svenska Handelsbanken > New York. > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own