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