Re: Current identity value for GENERATED ALWAYS AS IDENTITY column

I'm not exactly sure what you mean by "querying Identity_Val_Local() in
another job", but a null value indicates that no insert related to a table
with identity columns has been performed at the current level in the job.
You may want to take a look at
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_71/db2/rbafzscaidentity.htm
for
further information on this function.

On Wed, Nov 22, 2017 at 11:29 AM, Dan <dan27649@xxxxxxxxx> wrote:

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();

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-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