Re: SQLRPGLE - get the RRN of an inserted row

In RPG you can also use FEOD with the N extender which will guarantee the record is passed to the OS but avoids the slow down caused by FEOD or FRCRATIO(1) making the OS wait while the data is written to disk.

I have not tested to ensure that the RRN is updated in this case but I'm pretty sure it would be.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Mar 27, 2018, at 11:03 AM, Dan <dan27649@xxxxxxxxx> wrote:

Keep in mind that if your program blocks record output, INFDS 397-400 will
only update when the blocks are written to disk. You *could* use OVRDBF
FRCRATIO(1), but that might seriously degrade performance. The DB trigger
Dave mentioned is probably your best bet.

- Dan

On Mon, Mar 26, 2018 at 10:06 AM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

If you're using RLA then the feedback information data structure
has that information.

D DB_RRN 397 400I 0

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD