sequence Hi.
I'm trying to change sequence name like this:
CREATE SEQUENCE seq_transid
START WITH (VALUES NEXTVAL FOR transid_seq+1)
INCREMENT BY 1
NO MAXVALUE
NO CYCLE
CACHE 24
;
drop sequence seq_transid;
I get Exception:
An unexpected token "((VALUES NEXTVAL FOR tran" was found following
"transid
START WITH". Expected tokens may include: "<signed_numeric_literal>".
SQLSTATE=42601
What is the problem?
Thanx,
Alan |