To create a sequence in DB2, execute:create sequence <seq-name> start with <val> To drop a sequence in DB2, execute:drop sequence <seq-name> restrict To get the next value from a sequence, execute:values nextval for <seq-name> Note: This is the Oracle equivalent to:select <seq-name>.nextval from dualTo get the current (previous) value from a sequence, execute:values prevval for <seq-name>
To drop a sequence in DB2, execute:drop sequence <seq-name> restrict
To get the next value from a sequence, execute:values nextval for <seq-name>
Note: This is the Oracle equivalent to:select <seq-name>.nextval from dualTo get the current (previous) value from a sequence, execute:values prevval for <seq-name>