SQL Trace

SQL tracing is available via the -t 2 or -t 0x2 command-line option. The following SQL messages may appear in the log file:

Message

Description

SQL=sqltext

Indicates general SQL tracing where sqltext is the actual SQL command sent to the relational database.

SQL[number]=sqltext

Indicates SQL tracing that involves host variables in the DATABridge Client for Oracle when the configuration parameter aux_stmts has a nonzero value.

Number is the cursor number, and sqltext is the actual SQL command sent to the relational database.

SQL_DATA[number]= ...|...|...

This message shows the data being passed to the database API when executing updates involving previously parsed SQL statements that use host variables. Number is the stmt number.