SET SEQUENCE
SET SEQUENCE <sequence_name> VALUE <value>
Usage
The SET SEQUENCE statement sets the sequence value dynamically.
The <value> is the sequence number as a numeric value. The sequence values are stored in BIGINT data type.
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
1 rows fetched.
See also