Specifies that the JDBC Driver Manager Trace tool should trace a connection to the database you access through the PowerBuilder JDBC interface.
JDB JDBC
TraceFile='tracefile_name'
None
The JDBC Driver Manager Trace logs errors and informational messages originating from the Driver object currently loaded (such as the Sybase jConnect JDBC driver) when PowerBuilder connects to a database through the JDBC interface. It writes this information to a log file (default is JDBC.LOG) or to a file you specify. The amount of trace output varies depending on the JDBC driver being used.
You can start and stop the JDBC Driver Manager Trace in the PowerBuilder development environment by editing the database profile for the connection you want to trace. You can also start and stop the JDBC Driver Manager Trace in a PowerBuilder application by specifying the TraceFile parameter in the appropriate script.
For more information about using the JDBC Driver Manager Trace tool, see Connecting to Your Database.
To start the JDBC Driver Manager Trace and specify a log file:
Database profile Select the Trace JDBC Calls check box and type the following in the Trace File box on the Options page in the Database Profile Setup dialog box:
c:\temp\jdbctrce.log
Application Type the following in code:
SQLCA.DBParm="TraceFile='c:\temp\jdbctrce.log'"
