SAP ABAP Data Element QQHVAR (iSeries: Host Variable Values (Database Monitor))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Data Element	QQHVAR
Short Description	iSeries: Host Variable Values (Database Monitor)

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	QQCHAR1000
Data Type	LCHR	Long character string, requires preceding INT2 field
Length	1000
Decimal Places	0
Output Length	1000
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	11	HostVarVal
Medium	21	Host Var. Values
Long	41	Host Variable Values
Heading	55	Host Variable Values

Documentation

Definition

QQHVAR contains the host variables used in the most expensive execution of a statement.

Example

The Open SQL statement (with an appropriate internal table declaration for itab) collects all statements (library/SQL package/statement name), the timestamp of their most expensive execution, and their host variable values used in the most expensive execution:
select b~qqplib b~qqpnam b~qqsnam b~qqpltu a~qqhvar_len a~qqhvar
into corrseponding fields of table itab
from SQHVAR_DB4 as a
inner join SQ1000_DB4 as b
where a~qqkey = b~qqkey.

History

Last changed by/on	SAP	20070813
SAP Release Created in