SAP ABAP Data Element QQSTN (Statement number (unique))
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 QQSTN
Short Description Statement number (unique)  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type QQSTN    
Data Type INT4   4-byte integer, integer number with sign 
Length 10    
Decimal Places 0    
Output Length 10    
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 Stmt no. 
Medium 13 Statement no. 
Long 16 Statement number 
Heading Stmt no. 
Documentation

Definition

In combination with QQC104 (QQPLIB)/QQC103 (QQPNAM), QQSTN defines which statement in which SQL package is used to implement the query.

This information is only available for records with QQRID 1000.

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 for implementing several queries which differ with regard to the host variable values.

See: QQC103 (QQPNAM).

Example

QQSTN: 5 QQC104(QQPLIB): R3C8131960 QQC103(QQPNAM): SAPLSDTBA4
means that the access path of the 5th statement in the SQL package R3C8131960/SAPLSDTBA4 was used to implement the query.

The native SQL statement
SELECT qqhvar, qqplib, qqpnam, qqstn,qqsttx
FROM r3c81data/qqq1000 b, r3c81data/qqq3010 a
WHERE a.qqjfld = b.qqjfld and
a.qqucnt=b.qqucnt and
a.qqrcnt = b.qqrcnt and
qqpnam = 'SAPLSDTBA4' and
qqplib = 'R3C8131960' and
qqstn = 5
lists all query runs including the host variable values that were implemented using the 5th prepared statement in R3C8131960/SAPLSDTBA4.
(In this example the SAP system ID is C81; R3C81DATA is the database library of the SAP System.)

History
Last changed by/on SAP  20070813 
SAP Release Created in