Previous Topic: Expression DumpNext Topic: Reporting on the Compound Boolean Selection Facility

REPORT (Generate Reports) › Statistics and Diagnostics Area (PXX) Report › Sample Report

Sample Report

The following is an example of an "expression tree" dump when an SQLCODE -41 (incompatible data types) was received.

 DATA BASE  SQL DUMP SUMMARY                                     1/06/2003
 12.21.56
 
 
 ERROR DETECTED IN PROGRAM  EXPRCONV   AT LINE  367
 ERROR MESSAGE TEXT:  DATATYPES OF OPERATION '>' NOT COMPATIBLE
 
 SQL ERROR CODE IS:     -41
 PLAN NAME IS:          ISDBXXXX45291775
 AUTHORIZATION ID IS:        WILRI01
 STATEMENT ID IS:       0
 DSF RETURN CODE IS:    BLANKS
 CA-STAR RETURN CODE IS:
 DB RETURN CODE IS:       (0)
 DB COMMAND IS:         QPRPD
                                                           1/06/2003 12.21.56
 LVL 1 NODE 047B3340 OP=047B32D2 NXT=00000000L QCB=047B3168 VAL=00000000 NAM=00000000
 ... . PROCTYPE = 0x8008  STEP=-01  OPER = 249 PREDPREP
 ... . RESULT  (#0000:00000.00000): UNKNOWN
   LVL 2 NODE 047B32D2 OP=00000000 NXT=047B330C    QCB=047B3168 VAL=0476F058 NAM=047C7B46
   ... . TBL 00 (#0000:00000.00008): CHAR (8) NOT NULL
   ... . NAME: COL1 >  COL4               .
   LVL 2 NODE 047B330C OP=00000000 NXT=047B3340L QCB=047B3168 VAL=0476F0B0 NAM=047C7B4E
   ... . TBL 00 (#0003:00015.00006): NUMERIC (5,0)
   ... . NAME: COL4                  .