By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

sequence

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In article <11**********************@g49g2000cwa.googlegroups .com>,
ak*****@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-'

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.