SET DEBUG FILE statement
Use the SET DEBUG FILE statement to identify the file that is to receive the runtime trace output of an SPL routine.
This statement is an extension to the ANSI/ISO standard for SQL.
Syntax
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| expression | Expression that returns a filename | Must be a valid filename | Expression |
| filename | Pathname of the file that contains the output of the TRACE statement | See Using the WITH APPEND Option | Quoted String. |
| filename_var | Host variable storing filename string | Must be a character type | Language specific |
Usage
This statement specifies the file to which the database server writes the output from the TRACE statement in the SPL routine. Each time the TRACE statement is executed, the trace information is added to this output file.