Home > IT Answers > AS/400 > Relative record number
Pwopen12
160 pts.
0
Q:
Relative record number
RRN, Relative Record Number
How do we see(display) relative record number(RRN)
ASKED: Apr 13 2009  8:29 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
MAGIC
180 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Apr 21 2009  6:19 AM GMT by MAGIC   180 pts.
Latest Contributors: Gilly400   23625 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

BigKat   2480 pts.  |   Apr 14 2009  1:09PM GMT

in what? SQL? RPG? …

 

Wpoulin   1085 pts.  |   Apr 14 2009  3:15PM GMT

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

 

WoodEngineer   2150 pts.  |   Apr 14 2009  3:47PM GMT

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.

 
0