SAP ABAP Data Element QQSTTX (iSeries: Statement Text (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	QQSTTX
Short Description	iSeries: Statement Text (Database Monitor)

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	QQLCHR
Data Type	LCHR	Long character string, requires preceding INT2 field
Length	8000
Decimal Places	0
Output Length	8000
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	Stmt. Text
Medium	21	Statement Text
Long	41	Statement Text
Heading	55	Statement Text

Documentation

Definition

QQSTTX contains the statement text of a statement.
If the text is longer than 8000 characters, it is truncated.
QQSTTX_LNG contains the length (number of characters) of the statement text.

Example

The Open SQL statement (with an appropriate internal table declaration for itab) collects all statements (library/SQL package/statement name) and the statement texts:
select b~qqplib b~qqpnam b~qqsnam a~qqsttx_lng a~qqsttx
into corrseponding fields of table itab
from SQTEXT_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