Is there a limit to the relative record number(RRN) for physical file on system i , we are on V5R4 version of OS400
Is there a limit to the relative record number(RRN) for a physical file on system i , we are on V5R4 version of OS400. If yes, what are the likely issues we would have to face?  

Answer Question   |  August 5, 2010  11:49 AM
i570 MMA, LIMIT, OS/400, OS400 Upgrade, Relative Record Number, V5R4

Duplicate record
When attempting to rewrite a record after moving/changing one of the components of the key, it hits a error – ie. duplicate key. But after investigation using sql, there is no such existing key value in the database. Why is this happening ?

Answer Question   |  May 10, 2009  12:05 AM
change value of key, duplicate error, Relative Record Number

Is RRN part of the record?
I have one doubt whether RRN is part of Record or not

Answer Question   |  May 6, 2009  4:27 AM
Relative Record Number, RRN

Relative record number
How do we see(display) relative record number(RRN)

Answer Question   |  April 21, 2009  8:29 PM
Relative Record Number, RRN

DB2/400
Hello Guys, In DB2/400 even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value “Y” or “N”. How to see this indicator field? How to see the DB2/400 RRN (Relative record number)field? I tried with RUNQRY command, [...]

Answer Question   |  July 22, 2009  11:37 AM
DB2, DB2/400, DB2/400 RRN, Relative Record Number, Reorganize Physical File Member, RGZPFM, RRN, RUNQRY

RPG – Subfile – Read using RRN
Is it possible to read a subfile record if its RRN number is known? In my case, when on a subfile record, if F4 is pressed a Prompt window is displayed to list codes. When a code is selected I want this selected code to appear in my subfile record for which the F4 was [...]

Answer Question   |  May 29, 2008  9:25 AM
Relative Record Number, RRN, Subfile