ENABLE_TRACE_ON¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command enables driver level tracing to the specified file. Enabling trace on an application and using it in conjunction with SQL_TEXT_MESSAGE is a good way to study particular problems you encounter in the driver. SQL_TEXT_MESSAGE allows you to insert sections of your code into the trace file. This command can also set the trace to three different levels, allowing different amounts of information to be logged. Note that trace files can become very large so it is good practice to only turn them on when specifically needed.

Syntax

ENABLE_TRACE_ON to {fileName} Debug_Level [{constant}]

Parameter

Description

fileName

The path of the file to send the trace to

constant

DETAIL_LEVEL1, DETAIL_LEVEL2, DETAIL_LEVEL3 (optional)

Example

ENABLE_TRACE_ON TO "C:\Temp\trace_file.log" DETAIL_LEVEL3