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.