SAP ABAP Data Element QQRCODAPR (Reason code)
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 | QQRCODAPR |
| Short Description | Reason code |
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 | 11 | Reason code |
| Long | 11 | Reason code |
| Heading | 2 | RC |
Documentation
Definition
QQRCODAPR explains why the database optimizer rebuilt the access plan for the statement.
Value range
- A1 - A file or member is not the same object as the one referenced when the access plan was last built. Some reasons why they might be different:
- Object was deleted and recreated
- Object was saved and restored
- Library list was changed
- Object was renamed
- Object was moved
- Object was overridden by a different object
- This is the first run of the query after the object containing the query has been restored - A2 - Access plan was built to use a reusable Open Data Path (ODP) and the optimizer chose to use a non-reusable ODP for this call.
- A3 - Access plan was built to use a non-reusable ODP and the optimizer chose to use a reusable ODP for this call.
- A4 - The number of records in the member has changed by more than 10% since the access plan was last built.
- A5 - A new access path exists over the member.
- A6 - An access path over the member that was used for this access plan no longer exists or is no longer valid.
- A7 - OS/400 Query requires the access plan to be rebuilt because of system programming changes.
- A8 - The CCSID of the current job is different from the CCSID of the job that last created the access plan.
- A9 - The value of one or more of the following is different for the current job than it was for the job that last created this access plan:
- Date format
- Date separator
- Time format
- Time separator - AA - The sort sequence table specified is different from the sort sequence table that was used when this access plan was created.
- AB - Storage pool changed or DEGREE parameter of CHGQRYA command changed.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
