Re: SQLRPGLE - get the RRN of an inserted row

On 24 March 2018 at 16:32, Booth Martin <booth@xxxxxxxxxxxx> wrote:

The file's rows do not, nor will they have, any field or combination of
fields that is guaranteed unique. Yet I have a need to update/delete
specific rows. rrn(FILENAME) seems to me the best/easiest way to make it
all work.

There will be rows added, and I would like to report the new rrn() on the
user's screen.

An identity column v. rrn() is a political discussion that takes place well
above my pay grade.

I personally feel that the technical discussion of the nitty gritty
details is exactly why the boss pays me.
I also understand that some bosses insist that technical expertise is
a fable, and that any manager can do our job better than we.

Perhaps the IO Feedback Area will be of value:
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/dm/rbal3dbiof.htm
Specifically, look at offset 30. I'm away from my machine at the
moment, but memory tells me it's 397 400i 0 in the INFDS. I can't say
that I ever checked it after a WRITE.

Good luck
--buck