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

The parser options and host language.

Field Name: QW0350OT

HOST LANG

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

SQL STATEMENT TYPE

The statement type.

Field Name: QW0350TY

SQL STATEMENT ID

The statement identifier.

Field Name: QW0350SI

SOURCE CCSID

The coded character set identifier (CCSID).

Field Name: QW0350CC

SQL SEGMENT

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

The complete SQL statement that is being parsed or only a part of it. Host variables in this field are represented by the following notation:

:h.

Field Name: QW0350SP

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

End program-specific programming interface information.