Hierarchy

⤷

⤷

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 | 8 | Stmt no. |
Medium | 13 | Statement no. |
Long | 16 | Statement number |
Heading | 8 | 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 |