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.
Using the WITH APPEND Option

Using the WITH APPEND Option

The output file that you specify in the SET DEBUG FILE statement can be a new file or existing file. If you specify an existing file, its current contents are deleted when you issue the SET DEBUG FILE TO statement. The first execution of a TRACE statement sends trace output to the beginning of the file.

If you include the WITH APPEND option, the current contents of the file are preserved when you issue the SET DEBUG FILE statement. The first execution of a TRACE statement adds the new trace output to the end of the file.

If you specify a new file in the SET DEBUG FILE TO statement, it makes no difference whether you include the WITH APPEND option. The first execution of a TRACE statement sends trace output to the beginning of the new file whether you include or omit the WITH APPEND option.