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.


Read syntax diagramSkip visual syntax diagramSET DEBUG FILE TO'filename'filename_varexpressionWITH APPEND

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


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.