Re: SQL Next Sequence

I am a bit late on the topic but you can just use the corresponding functions, see https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/db2/rbafzseqref.htm . NEXT VALUE will give you exactly that ... the next value of the sequence.

And to manually get the value of a sequence can come handy when you want have a unique key across multiple tables. F. e. if you have a customer table and a prospects table but want to have a unique key across both. And when a prospect turns to a customer you want to transfer the prospect to the customer table with keeping the same keep from the prospects table. (I know it is no longer unique across both tables but you probably know what I mean. And I don't say that it is a good data model but it is a valid case.)
My 2 cents.

Mihael

On 02.06.2018 17:28, Jack Callahan wrote:

Curious as to why you want to know the next sequence number.

You don't need to provide the value to add a row to your table- that's kind
of the point of allowing the system to generate the value.

If you want to know the identity value assigned to a row after it has been
inserted (so you can use it as a foreign key for other tables that refer to
this row), something like this should do the trick.

SELECT id INTO :newid
FROM FINAL TABLE
( INSERT INTO yourtable ...)