Re: SQL Next Sequence

[Mihael Schmidt <mihael@xxxxxxxxxxxxxx>]

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 ...)