IFCID 063 - SQL Statement

This topic shows detailed information about Record Trace - IFCID 063 - SQL Statement.

SQL STATEMENT  NETWORKID:  DEIBMIPS  LUNAME:  IPSAU851  LUWSEQ:     1
OPTIONS:  X'04' HOST LANG: N/A          SQL STATEMENT:
SELECT L.PLANNAME,L.SEQNO,K.*,HEX(CONTOKEN) FROM
SYSIBM.SYSPACKLIST L,SYSIBM.SYSPACKage K WHERE
L.PLANNAME = 'HSRTEP2L' AND (L.LOCATION = '*' OR
L.LOCATION = ' ') AND K.LOCATION = ' ' AND K.COLLID =
L.COLLID AND K.NAME = L.NAME UNION ALL SELECT
L.PLANNAME,L.SEQNO,K.*,HEX(CONTOKEN) FROM
SYSIBM.SYSPACKLIST L,SYSIBM.SYSPACKage K WHERE
L.PLANNAME = 'HSRTEP2L' AND (L.LOCATION = '*' OR
L.LOCATION = ' ') AND K.LOCATION = ' ' AND L.COLLID =
'*' AND K.NAME = L.NAME UNION ALL SELECT
L.PLANNAME,L.SEQNO,K.*,HEX(CONTOKEN) FROM
SYSIBM.SYSPACKLIST L,SYSIBM.SYSPACKage K WHERE
L.PLANNAME = 'HSRTEP2L' AND (L.LOCATION = '*' OR
L.LOCATION = ' ') AND K.LOCATION = ' ' AND L.COLLID =
'*' AND L.NAME = '*' UNION ALL SELECT
L.PLANNAME,L.SEQNO,K.*,HEX(CONTOKEN) FROM
SYSIBM.SYSPACKLIST L,SYSIBM.SYSPACKage K WHERE
L.PLANNAME = 'HSRTEP2L' AND (L.LOCATION = '*' OR
L.LOCATION = ' ') AND K.LOCATION = ' ' AND K.COLLID =
L.COLLID AND L.NAME = '*' ORDER BY 1 , 2 FOR FETCH
ONLY
STATEMENT IDENTIFIER:                  29011
TYPE OF STATEMENT   : DYNAMIC  CCSID:   1208
 

                                                           SQL STATEMENT               
                                                                                       
OPTIONS.............:             X'4'   HOST LANG........: N/A                        
SQL STATEMENT LENGTH:               65                                                 
SQL STATEMENT.......: EXPLAIN PLAN FOR SELECT * FROM DSN8130.EMP WHERE EMPNO = '000010'
                                                                                       
STATEMENT IDENTIFIER: 0                                                                
TYPE OF STATEMENT...: DYNAMIC            CCSID............:               37           
 

OPTIONS

This field consists of 8 bits. The bits indicate the parser options and the host language. The four most significant bits describe the parser options:

Bit 7

String delimiter (0 = apostrophe; 1 = quotation mark)

Bit 6

Decimal separator (0 = period; 1 = comma)

Bit 5

SQL delimiter (0 = apostrophe; 1 = quotation mark)

Bit 4

Mixed data (0 = no; 1 = yes)

Bit 3

Reserved

Bits 0 to 2

Host language

The three least significant bits (0 to 2) are the host language bit mask. The hexadecimal value indicates the host language:

001

Host language is Assembler

010

Host language is COBOL

011

Host language is PL/I

100

Host language is Dynamic SQL

101

Host language is FORTRAN

110

Host language is COBOL2

111

Look at HOST LANG field

Field Name: QW0063OT

HOST LANG

Additional host language option. This field is optional. When the OPTIONS host language bit mask is x'7' , it indicates the host language.

Field Name: QW0063HL

SQL STATEMENT

The SQL statement being processed.

Note:

• SQL text longer than 5000 characters is truncated.
• Host variables are represented as :H

Field Name: QW0063ST

STATEMENT IDENTIFIER

The type of statement.

Field Name: QW0063TY

TYPE OF STATEMENT

The statement identifier.

Field Name: QW0063SI

CCSID

The coded character set identifier (CCSID).

Field Name: QW0063CC