You can specify how the ODBC driver traces ODBC function calls. If tracing is activated, the system generates a file that contains the actual ODBC function calls.
Procedure
From Control Panel, navigate to Set up ODBC Data sources (32-bit) or Set up ODBC Data sources (64-bit) as appropriate for your version of Windows.
The ODBC Data Source Administrator window is displayed.
Click the Tracing tab.
Choose one of the following options:
Click Start Tracing Now to trace ODBC calls or observe ODBC activity.
Click Stop Tracing Now to stop tracing when the ODBC session is completed.
In the Log File Path area, click Browse to select or change the file to which the Informix driver writes tracing information. The default log file is \SQL.LOG.
Important:
Do not change the default entry in the Custom Trace DLL area.