Sequence &SQL Select

[c***@hotmail.com]

How to apply sequence into SQL select?

SELECT NEXT VALUE FOR Q1_ID; .....?

Thanks In Advance.

[b***@to.com]

Hi,

SELECT NEXT VALUE FOR <sequence name> FROM SYSIBM.SYSDUMMY1

could do the trick.

Greetings from Stuttgart,
Bogdan

[c***@hotmail.com]

It's work!!

Thanks Bogdan.