Re: RRN of an IP record

Use an override to the blocking of the data, to effect one row at a time retrieval from the database, by issuing a request to OVRDBF SEQONLY(*YES 1) for the file being accessed. Issue that request with the appropriate override scope, prior to starting the program for the debug activity. The active row should then be more obviously inferred from RRN in the Open Files output, because the data from multiple rows will not have been buffered into the area provided by the RPG runtime.

Regards, Chuck

Marchini, Richard wrote:

Thank you, that's the information I was looking for (although I was hoping for a more favorable answer). I suppose with a large input
file, we can narrow down the range of records to manually examine.

Crispin Bates wrote:

If the data is blocked, I don't know that there is any way to tell
what record is being processed by the program. *OPNF on
DSPJOB/WRKJOB show the Jobs Open files, not where the RPG program
is in the block. This isn't specific to Primary files...

"Marchini, Richard" wrote:

Good thought, but, no, it's in arrival sequence. By the way, we determined which record caused the error by manually viewing the
data and comparing it. That works with a relatively small file,
but not if the file is large.