A NEXT VALUE expression returns the value generated by a sequence generator.
By specifying FOR PUBLIC USAGE when you define a NEXT VALUE expression, all users can access a sequence generator. Only the owner can access any other sequence generator.
NEXT-VALUE-expression::= NEXT VALUE FOR [authorization-identifier.]sequence-generator-identifier |
CREATE TABLE STOCK(
PID INTEGER,
PNAME NCHAR(8),
PRICE INTEGER)
CREATE SEQUENCE SEQ1
START WITH 1000
INCREMENT BY 1
MAXVALUE 9999
INSERT INTO STOCK VALUES(NEXT VALUE FOR SEQ1, N'Pants', 1200)
INSERT INTO STOCK VALUES(NEXT VALUE FOR SEQ1, N'Shirt', 1000)
INSERT INTO STOCK VALUES(NEXT VALUE FOR SEQ1, N'Sweater', 1500)
UPDATE STOCK SET PID = NEXT VALUE FOR SEQ1 WHERE PID = 1001