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-------+
                              +-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	traces per compilation unit directives the first time a compilation unit is enountered 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
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