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

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	QQC18
Data Type	CHAR	Character String
Length	18
Decimal Places	0
Output Length	18
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. Name
Medium	21	Statement Name
Long	41	Statement Name
Heading	55	Statement Name

Documentation

Definition

QQSNAM is the ID of a prepared statement within an SQL package.

Use

In combination with QQPLIB and QQPNAM, QQSNAM identifies the prepared statement used to implement a query (that is, the execution of a statement).

Note

The prepared statement in an SQL package comprises the control structures used to execute a query employing this statement.
A single prepared statement in an SQL package can be used to implement several queries which differ only with regard to the host variable values.

See: QQPNAM.

Example

QQPLIB: R3C8131960 QQPNAM: TALIMGC QQSNAM: WqpqqØØØØ0
means that the access path of the statement WqpqqØØØØ0 in the SQL package R3C8131960/TALIMGC was used to implement the query.

History

Last changed by/on	SAP	20070813
SAP Release Created in