SET TRACELEVEL

Enables you to dynamically set or change the reporting level of OpenESQL traces for native applications.

Syntax:

>>--EXEC SQL--SET TRACELEVEL--.-0-------.---END-EXEC--><
                              +-1-------+
                              +-2-------+
                              +-3-------+
                              +-4-------+
                              +-5-------+
                              +-6[9]-------+
                              +-OFF-----+
                              +-DEFAULT-+

Parameters:

0

Turns off the OpenESQL trace.

1

The following information is written to the trace file:

BEGIN: traces main SQL directives
END: Indicates end of run
DIRECTIVES: T races per compilation unit directives the first time a compilation unit is encountered at run time
PREPARE: Identifies the original source code when a statement is prepared
DISPOSE: Provides summary information for overall statement usage when a statement is removed from the prepared statement cache at disconnect time
FLUSH: Provides summary information for overall statement usage when a statement is flushed from the cache usually due to a cache overflow

2

The following information is written to the trace file in addition to the information written when you set the trace level to 1:

OPEN
EXECUTE: Provides the number of rows selected, inserted, or updated
EXEC_IMMED EXECUTE: Provides the number of rows selected, inserted, or updated
ODBCCLOSE: Provides summary information for the current cursor use
STMT CHANGED: Reports new concurrency and scroll option settings when the ODBC driver uses different settings than those requested by OpenESQL

3

The following information is written to the trace file in addition to the information written when you set the trace level to 2:

ODBCFETCH: Provides the number of rows fetched
COBOLFETCH: Provides the number of rows returned to the COBOL application

4

The following information is written to the trace file in addition to the information written when you set the trace level to 3:

EXEC_SQL_BEGIN
EXEC_SQL_END

5[9]

The following information is written to the trace file in addition to the information written when you set the trace level to 4:

ODBC_CALL_START
ODBC_CALL_END

6[9]

Only the following information is written to the trace file:

ODBC_CALL_START
ODBC_CALL_END

OFF

Turns off the OpenESQL trace

DEFAULT

Resets the trace setting to the value set by the SQL TRACELEVEL directive. If the TRACELEVEL directive was not used to compile a program, this is equivalent to setting this option to OFF.

Example:

EXEC SQL SET TRACELEVEL DEFAULT END-EXEC