SEO

#1 (**permalink**) 02-27-2008, 05:00 AM

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

#2 (**permalink**) 02-27-2008, 05:00 AM

In article <1128585941.103685.164340@g49g2000cwa.googlegroups .com>,
aklikic@yahoo.com says...

> 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?

I guess reading the manual is the problem?

You need to specify a 'numeric constant'.

>>-CREATE SEQUENCE--sequence-name--*--+---------------+--*------>
'-AS--data-type-'
>--+------------------------------+--*-------------------------->
'-START WITH--numeric-constant-'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode