SET SEQUENCE
Note The SET SEQUENCE statement is deprecated. Use the ALTER SEQUENCE statement instead, see
ALTER SEQUENCE.
SET SEQUENCE sequence‑name VALUE value
Usage
Use the SET SEQUENCE statement to set a sequence value dynamically. The sequence values are stored in BIGINT data type.
Parameters, clauses, keywords, and variables
▪ value: The sequence number as a numeric value. When the sequence value has been set, the next returned value is value + 1.
Examples
SELECT MYSEQ.NEXT;
MYSEQ.NEXT
8
1 rows fetched.
SET SEQUENCE MYSEQ VALUE 5;
Command completed successfully, 0 rows affected.
SELECT MYSEQ.NEXT;
MYSEQ.NEXT
6
1 rows fetched.
Go up to