Re: Help: - TRACE not working in stored procedure
rrazdan@gtscorp.com wrote:
>
> My stored procedure does not generate a TRACE file. I am using Informix
> OWS 7.12 TC5 on a WinNT 4.0. I also tried using a APPEND TO with a
> manually created trace file but still no success. Am I missing
> something ? I am doing this using Informix SQL editor.
>
> CREATE PROCEDURE trace_test( ) RETURNING CHAR (10);> DEFINE junk CHAR(10);
>
> SET DEBUG FILE TO 'foo.tra';
Have you tried using a full pathname for the file?
> TRACE 'Start Trace';
> TRACE ON;
> LET junk = 'concat' || 'junk';
> TRACE OFF;
> RETURN junk;
> END PROCEDURE
Cheers,
--
Mark.
+------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| The Informix FAQ is at http://www.iiug.org |
|mailto:marks@west.co.za +-----------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work, force it! |
|Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!|
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+-----------------------------------------+