SAP ABAP Data Element QQRCODTMF (iSeries: Reason Code for Temp. Table (Database Monitor))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB4 (Application Component) DB2 for AS/400
⤷
STU4 (Package) CCMS / AS/400
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 | QQRCODTMF |
| Short Description | iSeries: Reason Code for Temp. Table (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 | 10 | ReasonCode |
| Medium | 21 | Reason Code |
| Long | 41 | Reason Code |
| Heading | 55 | Reason Code |
Documentation
Definition
QQRCODTMF describes why the database optimizer used a temporary file (created by the database optimizer) to implement the statement exexution.
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.
- F9
- File is a Join Logical File and its join type does not match the join type specified in the query.
- FA
- Format specified for the logical file references more than one physical file.
- FB
- File is a complex SQL view requiring a temporary result file to contain the result of the SQL view.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
