Re: Current identity value for GENERATED ALWAYS AS IDENTITY column

[Dan <dan27649@xxxxxxxxx>]

Thanks John!  This works for my immediate testing purposes.  I was able to
query this in a STRSQL session in the same interactive job in which a
called program issued a RUNSQL insert statement.  Out of curiosity, I tried
querying Identity_Val_Local() in another job and got a null returned.  It
would be nice to have a way to determine from any job the last identity
value generated for any file.

Charles, this was just for testing, so no permanent code needed for this.
The file in question was cleared, so I wanted to know what identity value
the next insert would generate before actually doing the insert.

- Dan

On Wed, Nov 22, 2017 at 11:03 AM, <JRusling@xxxxxxxxxxx> wrote:

> Maybe this helps. . . but it returns the value for the record just
> created, not the current identy (next) value.
> I call it immediately after a native i/o write operation.
>
>    // Get the File Id# for the record that we just added
>    exec sql set :rtnval = Identity_Val_Local();