Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SET DEBUG FILE statementUse the SET DEBUG FILE statement to identify the file that is to receive the runtime trace output of an SPL routine.

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.