solidDB Help : solidDB reference : SQL: Statements : SET : SET SEQUENCE
  
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
SET