Format of the Database Trace log

The specific content of the Database Trace log file depends on the database you are accessing and the operations you are performing. However, the log uses the following basic format to display output:

COMMAND: (time)
   {additional_information}

Parameter

Description

COMMAND

The internal command that PowerBuilder executes to perform the database operation.

time

The number of microseconds it takes PowerBuilder to perform the database operation. The precision used depends on your operating system’s timing mechanism.

additional_information

(Optional) Additional information about the command. The information provided depends on the database operation.

Example

The following portion of the log file shows the commands PowerBuilder executes to fetch two rows from a SQL Anywhere database table:

FETCH NEXT: (0.479 MS)
 COLUMN=400		 COLUMN=Marketing 	COLUMN=Evans
FETCH NEXT: (0.001 MS)
 COLUMN=500 	COLUMN=Shipping COLUMN=Martinez

If you opt to include DBI Names and Sum Time information in the trace log file, the log for the same two rows might look like this:

FETCH NEXT:(DBI_FETCHNEXT) (1.459 MS / 3858.556 MS)
 COLUMN=400		 COLUMN=Marketing 	COLUMN=Evans
FETCH NEXT:(DBI_FETCHNEXT) (0.001 MS / 3858.557 MS)
 COLUMN=500 	COLUMN=Shipping COLUMN=Martinez

For a more complete example of Database Trace output, see “Sample Database Trace output”.