IFCID350: SQL Statement
The IFCID350 DD contains the extracted IFCID 350 (SQL Statement) records.
Fields
The
IFCID350 DD has the following fields: - OPTIONS
- Shows the parser options and host language.
- 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
SOURCE CCSID
Field Name: QW0350CC
- 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.
- SQL LENGTH
- The total length of the SQL statement.
- 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..
SQL STATEMENT ID
Field Name: QW0350SI
SQL STATEMENT TYPE
Field Name: QW0350TY
Example

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 ...
