Home > IT Answers > AS/400 > Relative record number
pwopen12
230 pts.
 Relative record number
Relative Record Number, RRN
How do we see(display) relative record number(RRN)

Software/Hardware used:
ASKED: April 13, 2009  8:29 PM
UPDATED: April 21, 2009  6:19 AM
RELATED QUESTIONS
Answer Wiki:
Hi, If you use SQL you can select RRN as a field. Regards, Martin Gilbert. //// Hi, Using the command DSPPFM, you can trace out the RRN number. Thanks.
Last Wiki Answer Submitted:  April 21, 2009  6:19 am  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

in what? SQL? RPG? …

BigKat
 7,205 pts.
 

Pwopen12,

You don’t typically see the relative record number, it is a records placement with in a physical file. Is it the first record or the fifth record or the 500th record. That is its relative record number from the beginning of the file.

Hope this helps,
Bill Poulin

wpoulin
 2,480 pts.
 

In RPG, add a file info data structure to the file whose RRN you wish to see. One of the fields in the data structure will contain the RRN of the most recently accessed record.

In SQL, try Select rrn(fileName), fieldA, fieldB from fileName.

WoodEngineer
 5,555 pts.