IFCID 350 - SQL Statement

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

IFCID 350 records the complete text of a parsed SQL statement. These records are written when a static or dynamic SQL statement is bound.

Record trace - IFCID 350 - SQL Statement

The field labels shown in the following sample layout of Record Trace - IFCID 350 - SQL Statement are described in the following section. 


OPTIONS      : X'04'          HOST LANG : N/A
SQL SEGMENT  : PORTION        STMT ID   :                       N/A
STMT TYPE    : N/A            CCSID     :                       N/A
SQL LENGTH: 0
SQL STATEMENT:
OPTIONS

Shows the parser options and host language.

Field Name: QW0350OT

HOST LANG
Determines the host language. It can have the following values:
  • ASSEMBLER
  • COBOL
  • C
  • FORTRAN
  • PL/I
  • COBOL II
  • IBM COBOL
  • C++

Field Name: QW0350HL

SQL SEGMENT

Shows the first, the last, the complete, or a portion of the SQL statement.

Field Name: QW0350FG

STMT ID

The statement identifier.

Field Name: QW0350SI

STMT TYPE

The statement type. Possible values are DYNAMIC, STATIC, or N/P.

Field Name: QW0350TY

CCSID

The coded character set identifier (CCSID).

Field Name: QW0350CC

SQL LENGTH

The total length of the SQL statement. The maximum length is 5000 bytes.

Field Name: QW0350TL

SQL STATEMENT
Shows the complete SQL statement that is being parsed or only a part of it.
Note: Host variables in this field are represented by :h.

Field Name: QW0350SP