Re: Debug for Stored Procs

Posted in 1995

Gnana1 — 9 Jul 1995 20:56:30 -0400 — source: Informix-list mailing list archive (1991-1998)

It is possible to set debug file to "some_file", and issue set trace on command within each stored proc. This will cause the stored proc to output each step it executes and you may be able to study the results. However this option should not be turned on while handling production volume, as the response gets very very ugly. Refer to informix manuals for syntax of usage of "SET" command. Ravi.