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