Thread: sequence
View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 05:00 AM
alan_sec
 
Posts: n/a
Default 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

Reply With Quote