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:
|
1 2 |
COMMAND: (time) {additional_information} |
|
Parameter |
Description |
|---|---|
|
COMMAND |
The internal command that PowerBuilder executes |
|
time |
The number of microseconds it takes |
|
additional_information |
(Optional) Additional information about the |
Example
The following portion of the log file shows the commands
PowerBuilder executes to fetch two rows from a SQL Anywhere database
table:
|
1 2 3 4 5 6 7 8 |
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:
|
1 2 3 4 5 6 7 8 |
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.