Re: Get column generated identity value after WRITE in RPG

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

I take it you mean an RPGLE program, not SQLRPGLE.  If that's the case, 
then I'm not certain.  If you're willing to use EXEC SQL, though, it's easy:

Exec SQL SET :wLast = Identity_Val_Local();


On 12/28/2018 11:43 AM, Matt Olson wrote:
> Anyone know if its possible to get the generated identity column value after a WRITE in RPG?
>
> I know how to do it in SQL, but can't find info on how to do it with native IO.
>
> Thanks!
>
> Matt