IFCID350: SQL Statement

The IFCID350 DD contains the extracted IFCID 350 (SQL Statement) records.

Fields

Begin program-specific programming interface information.
The IFCID350 DD has the following fields:
OPTIONS
Shows the parser options and host language.
Field Name: QW0350OT
HOST LANG
Shows the host language. HOST LANG can have the following values:
  • ASSEMBLER
  • COBOL
  • C
  • FORTRAN
  • PL/I
  • COBOL II
  • IBM® COBOL
  • C++
  • N/A
Field Name: QW0350HL
Start of changeSOURCE CCSIDEnd of change
Start of changeEnd of change
Start of changeField Name: QW0350CCEnd of change
SQL SEGMENT
Shows a segment of the SQL statement. SQL SEGMENT can have the following values:
FIRST
The first segment of the SQL statement.
LAST
The last segment of the SQL statement.
COMPLETE
The entire SQL statement.
OTHER
Some other segment of the SQL statement.
Field Name: QW0350FG
SQL LENGTH
The total length of the SQL statement.
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
Start of changeSQL STATEMENT IDEnd of change
Start of changeEnd of change
Start of changeField Name: QW0350SIEnd of change
Start of changeSQL STATEMENT TYPEEnd of change
Start of changeEnd of change
Start of changeField Name: QW0350TYEnd of change

Example

Start of change
OPTIONS      : X'04'             HOST LANG : N/A       
SQL STATEMENT TYPE: DYNAMIC                            
SQL STATEMENT ID  : 00000000000000000000               
SOURCE CCSID      : 00037                              
SQL SEGMENT  : FIRST             SQL LENGTH: 0000117158
SQL STATEMENT: INSERT INTO CCC501TAB ...
End of change
End program-specific programming interface information.