Host Variables
This block shows the host variables to represent the values that will be sent to or received from the SQL statement.
- The number of shown host variables is limited to 100.
- A warning message is issued in DPMLOG, if the limit is reached or if SQLDA entries are missing.
Workload Host Variables Example
Here is an example of the workload host variables.
--- HOST VARIABLES -------------------------------------------------------------------------------------------------------
LOCATION : SYSDSNI COLLID : PMDEMO PROGNAME : DYNSEL08 CONSIS_TOKEN : X'5A427634E644C54'
STMT_NO : 133 FORMAT : 1 - COMPLETE NO.SQLDA ENTRIES : 3
..........................................................................................................................
ENTRY_NO. : 1 NAME : NULL_INDICATOR : NO SQLTYPE : 452
DATA_TYPE : FIXED-LENGTH CHARACTER STRING DATA_LENGTH : 6
PRECISION : N/A SCALE : N/A ADDR_HOST_VAR : X'00064DD0' ADDR_IND_VAR : X'000650A8'
DATA : 000001
........................................................................................................................
ENTRY_NO. : 2 NAME : NULL_INDICATOR : NO SQLTYPE : 452
DATA_TYPE : FIXED-LENGTH CHARACTER STRING DATA_LENGTH : 6
PRECISION : N/A SCALE : N/A ADDR_HOST_VAR : X'00064DD8' ADDR_IND_VAR : X'000650A8'
DATA : 000001
........................................................................................................................
ENTRY_NO. : 3 NAME : NULL_INDICATOR : NO SQLTYPE : 452
DATA_TYPE : FIXED-LENGTH CHARACTER STRING DATA_LENGTH : 6
PRECISION : N/A SCALE : N/A ADDR_HOST_VAR : X'00064DE0' ADDR_IND_VAR : X'000650A8'
DATA : 000001
........................................................................................................................ Field description
Here is a description of the field labels shown in the workload host variables block.- LOCATION
-
Location name.
Field Name: QW0247LN
- COLLID
-
Package collection identifier.
Field Name: QW0247PC
- PROGNAME
-
Program name.
Field Name: QW0247PN
- CONSIS_TOKEN
-
Not present (N/P) is shown for this field if the value is X'40' or X'00'; otherwise the hexadecimal value of the field is shown
Field Name: QW0247TS
- STMT_NO
-
Statement number.
Field Name: QW0247SN
- FORMAT
- The format of the SQLDA. Possible values are:
- B'1000'
-
0 - COMPRESSED- Is a compressed form of the SQLDA.
- B'0100'
-
1 - COMPLETE- Is a complete SQLDA containing the data type, address, and address of the indicator variable for each host variable.
- B'0010'
-
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
- ENTRY_NO.
-
SQLDA entry number.
Field Name: QW0247NO
- NAME
-
SQLDA name, if Format 1 SQLDA. The first two bytes are the length of the NAME and are not shown.
Field Name: QW0247NA
- NULL_INDICATOR
- Null indicator values:
- YES, if X'00'
- NO, if X'FF'
Field Name: QW0247NL
- SQLTYPE
-
SQL type (see Db2® SQL Reference).
Field Name: QW0247TY
- DATA TYPE
- 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 INTEGER- 500, 501
SMALL INTEGER
Note:- Any other SQLTYPES are shown as:
NON DISPLAYABLE DATA - Values are shown in Db2 internal format.
Field Name: QW0247TY
- PRECISION
-
If the field is decimal (484 or 485), this is the precision.
Field Name: QW0247LP
- SCALE
-
If the field is decimal (484 or 485), this is the scale.
Field Name: QW0247LS
- ADDR_HOST_VAR
-
The address of the host variable in the application address space.
Field Name: QW0247PT
- ADDR_IND_VAR
-
The address of the indicator variable, if the value in QW0247TY is odd (NULLABLE).
Field Name: QW0247IN
- DATA
-
The host variable data.
Field Name: QW0247DA