IFCID 247 - SQLDA Data and Input Host Variable Data

This topic shows detailed information about Record Trace - IFCID 247 - SQLDA Data and Input Host Variable Data.

IFCID 247 records SQLDA data and INPUT HOST VARIABLE data are related to a user application program. Each host variable is traced individually as it is moved from the user application area to the Db2 address space.

For dynamic SQL statements of length 5000 or less, you can use these records in combination with records from IFCID 064 and IFCID 063 to determine which statements are associated with which host variables. To do this, you need to match the statement number in this record to the statement number in an IFCID 064 record. An IFCID 063 Record that follows the IFCID 064 record that has the same CORRELATION ID and ACE values contains the SQL statement associated with the host variables.

Record trace - IFCID 247 - SQLDA Data and Input Host Variable Data

The field labels shown in the following sample layout of Record Trace - IFCID 247 - SQLDA Data and Input Host Variable Data are described in the following section. 


INPUT HOST VARIABLE TRACING
LOCATION NAME: PMO5D851
COLLECTION ID: ADBL410
PROGRAM NAME : ADB2REE
STATEMENT NUMBER  :       2536      CONSISTENCY TOKEN      : X'1725896E1B46AEB8'
LENGTH EACH SQLDA ENTRY:    12      NUMBER ENTRIES IN SQLDA:     1       FORMAT SQLDA         : B'1000'
.........................................................................................................................
SQLDA ENTRY
SQLDA NAME: 'BLANK'                            SQLDA ENTRY NUMBER:          1   DATA TYPE     :   452   LENGTH:    18
ADDRESS TO DATA          : X'1E44B692'         PRECISION (IF DEC):        N/A   SCALE (IF DEC):   N/A
ADDRESS TO NULL INDICATOR: X'FF000000'         NULL INDICATOR    : NO
.........................................................................................................................
SQLDA DATA SECTION
LENGTH OF DATAREA: X'0012'
SQLDA DATA:
0000  43555252  454E5420  53455256  45522020   2020                                    | .....+............
LOCATION NAME

Location name.

Field Name: QW0247LN

COLLECTION ID

Package collection identifier.

Field Name: QW0247PC

PROGRAM NAME

Program name.

Field Name: QW0247PN

STATEMENT NUMBER

Statement number.

Field Name: QW0247SN

CONSISTENCY TOKEN

The consistency token.

Field Name: QW0247TS

LENGTH EACH SQLDA ENTRY

Length of each SQLDA entry.

Field Name: QW0247LE

NUMBER ENTRIES IN SQLDA

Number of entries in the SQL data area.

Field Name: QW0247NE

FORMAT SQLDA
The format of the SQLDA. Possible values are:
0 - COMPRESSED
Is a compressed form of the SQLDA.
1 - COMPLETE
Is a complete SQLDA containing the data type, address, and address of the indicator variable for each host variable.
2 - FIXED LENGTH
Is a variable length character format containing the length of the string and text.
? - UNKNOWN

Is shown, if none of the above field names is used.

Field Name: QW0247FE

SQLDA NAME

SQLDA name, if Format 1 SQLDA. The first two bytes are the length of the NAME and are not shown.

Field Name: QW0247NA

SQLDA ENTRY NUMBER

SQLDA entry number.

Field Name: QW0247NO

DATA TYPE
Is derived as described in Db2 SQL Reference , based on the SQLTYPE:
384, 385
DATE
388, 389
TIME
392, 393
TIMESTAMP
448, 449
VARYING LENGTH CHARACTER STRING
452, 453
FIXED-LENGTH CHARACTER STRING
456, 457
LONG VARYING CHARACTER STRING
480, 481
FLOATING POINT
484, 485
PACKED DECIMAL
496, 497
LARGE INTERGER
500, 501
SMALL INTEGER
Note:
  • Any other SQLTYPES are shown as: NON DISPLAYABLE DATA
  • Values are shown in Db2 internal format.

Field Name: QW0247TY

LENGTH

Length of data for this entry. If the field type is decimal (484 or 485), the length is not applicable.

Field Name: QW0247LD

ADDRESS TO DATA

The address of the host variable in the application address space.

Field Name: QW0247PT

PRECISION (IF DEC)

If the field type is decimal (484 or 485), this is the precision.

Field Name: QW0247LP

SCALE (ID DEC)

If the field is decimal (484 or 485), this is the scale.

Field Name: QW0247LS

ADDRESS TO NULL INDICATOR

The address of the indicator variable, if the value in QW0247TY is odd (NULLABLE).

Field Name: QW0247IN

NULL INDICATOR
Null indicator values:
  • YES, if X'00'
  • NO, if X'FF'

Field Name: QW0247NL

LENGTH OF DATAREA

Field Name: QW0247LL

SQLDA DATA

Field Name: QW0247DA