SAP ABAP Data Element QQRCODSRT (iSeries: Reason Code (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	QQRCODSRT
Short Description	iSeries: Reason Code (Database Monitor)

Data Type

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

Documentation

Definition

QQRCODSRT describes the reason why the database optimizer implemented the statement execution using a database sort.

Value range

F1

Query contains grouping fields (GROUP BY) from more than one file, or contains grouping fields from a secondary file of a join query that cannot be reordered.

F2

Query contains ordering fields (ORDER BY) from more than one file, or contains ordering fields from a secondary file of a join query that cannot be reordered.

F3

The grouping and ordering fields are not compatible.

F4

DISTINCT was specified for the query.

F5

UNION was specified for the query.

F6

Query had to be implemented using a sort. Key length of more than 2000 bytes or more than 120 key fields specified for ordering.

F7

Query optimizer chose to use a sort rather than an access path to order the results of the query.

F8

Perform specified record selection to minimize I/O wait time.

History

Last changed by/on	SAP	20070813
SAP Release Created in