INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Compliments on a fantastic web site. I have learned so much from my threads and even if sometimes I cannot solve the problem, it gives me the reassurance that I am not the only one putting up with it!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > IBM: DB2 Forum

Hi All I would like to know if i

Read More Threads Like This One

Motlatjo (Programmer)

16 Jul 12 10:58

Hi All

I would like to know if it is possible to set the Start With of a Sequence as a max value of an Integer field in a table?
I tried to do this and i could not get it:

CREATE SEQUENCE MySeq
AS INT
START WITH (SELECT MAX(ID) FROM TABLE1)
INCREMENT BY 1
NO MAXVALUE
NO CYCLE
CACHE 200
ORDER;

Thanks in advance

MarcLodge (Programmer)

16 Jul 12 18:45

Hi,
I don't think you can specify START in this fashion. I believe you might be able to achieve this usingand insert into the table using NEXTVAL but am not sure, so you'd have to look into this.

Marc

Motlatjo (Programmer)

18 Jul 12 3:22

Hi Marc

The issue is that i'm doing this in different servers, I ran The first Sequence in the first server1 (Next Value for Sequence1, so after extracting the data, i exported it to a table in another table in another server2, So there is a Sequence that generate the ID column of this table, so i need to tell the Sequence to Take the MaxValue of the ID in the table, as the Start value.

Thanks in advance

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To IBM: DB2