This section gives an example of Database Trace output that you might see in the log file.
The example traces a connection to an ODBC database named ASA Sample. The output was generated while running a PocketBuilder application that displays information about employees. The SELECT statement shown retrieves information from the Employee table to display the IDs, names, and birth dates of employees. (In the trace output, each command line is prefixed with a hexadecimal string enclosed in parentheses and followed by a colon. This prefix is omitted from the output shown here.)
/*--------------------------------------------------*/ /* 5/1/2004 09:00 */ /*--------------------------------------------------*/ LOGIN: (40 MilliSeconds) CONNECT TO trace odb: DBPARM=ConnectString='DSN=ASA Sample;UID=dba;PWD=sql' SERVER=asademo (0 MilliSeconds) PREPARE: (0 MilliSeconds) BEGIN TRANSACTION: (0 MilliSeconds) PREPARE: select "employee"."emp_id" , "employee"."emp_fname" , "employee"."emp_lname" , "employee"."birth_date" from "employee" (0 MilliSeconds) BIND SELECT OUTPUT BUFFER (DataWindow):(0 MilliSeconds) ,len=44,type=FLOAT,pbt=3,dbt=0,ct=0,prec=0,scale=0 ,len=22,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0 ,len=22,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0 ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0 EXECUTE: (0 MilliSeconds) FETCH NEXT: (0 MilliSeconds) COLUMN= 01COLUMN=Fran COLUMN=Whitney COLUMN=06-05-1958 255:00:00:000000 FETCH NEXT: (0 MilliSeconds) COLUMN= 02COLUMN=Matthew COLUMN=Cobb COLUMN=12-04-1960 255:00:00:000000 // ... // Additional FETCH NEXT statements omitted // ... FETCH NEXT: (0 MilliSeconds) COMMIT: (10 MilliSeconds) DISCONNECT: (10 MilliSeconds) SHUTDOWN DATABASE INTERFACE: (0 MilliSeconds)
