Hierarchy
⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
⤷ STU4 (Package) CCMS / AS/400
Basic Data
Data Element | QQRRN |
Short Description | iSeries: Relative Record Number (Database Monitor) |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | INT4 | |
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 | 11 | Rel.Rec.No |
Medium | 21 | Relative Record No. |
Long | 41 | Relative Record Number |
Heading | 55 | Relative Record Number |
Documentation
Definition
QQRRN is the relative record number of a record within a file member.
The relative record number is a DB2 UDB for iSeries internally managed number uniquely assigned to each row of a file member (that is, an SQL table). This number is unique at any one point in time, but can change over time, for example when the file member is reorganized with the RGZPFM command.
Use
The relative record number is used internally by DB2 UDB for iSeries for multiple purposes.
The relative record number must be used with caution since it is subject to change.
Example
The relative record number of a record can be accessed using SQL with the SQL function RRN.
The following SQL statement returns the relative record number and the primary key fields of the SAP table T000:
SELECT RRN(T000), MANDT FROM T000
The following statement returns the record with the relative record number 1:
SELECT * FROM T000 WHERE RRN(T000) = 1Definition
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in |