Relative record number

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

pwopen12245 pointsBadges:

How to find indicator and relative record number fields in DB2/400

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...

BibinGeorge130 pointsBadges:

Is there a limit to the relative record number(RRN) for physical file on system i?

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?

JohnsonMumbai1,480 pointsBadges:

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 ?

JEKLOW5 pointsBadges:

Is RRN part of the record?

I have one doubt whether RRN is part of Record or not

Swpa5 pointsBadges:

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 pressed. In my case I have RRN...

Kundankumar 8375 pointsBadges: