Re: SQL on V5R1

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Rob,

Read the whole thread / message...

He's dealing with v5r1, which doesn't have IDENTITY and thus doesn't have
​
IDENTITY_VAL_LOCAL...

I suggested a BEFORE INSERT trigger could emulate some of the functionality
butt that there would be downsides.

Charles

On Mon, Oct 19, 2015 at 9:02 AM, <rob@xxxxxxxxx> wrote:

> Charles,
>
> <snip>
> Lots of downsides to this, including the fact that there'd be no built in
> way to let the program doing the write know what identity value was
> generated.
> </snip>
>
> There are multiple ways of learning the last generated identity column.
> One is by the scalar built in function
> ​​
> IDENTITY_VAL_LOCAL as in
> INSERT INTO EMPLOYEE
>     (NAME, SALARY, DEPTNO)
>     VALUES('Rupert', 989.99, 50)
>
>   VALUES IDENTITY_VAL_LOCAL() INTO  :IVAR
> I suspect this came out when, or after, support for GENERATED was added