Hi,

Is there a way to set the count for a auto incrementing field after the the table has been built? (or do I have to set the counter start values in the build code?)

I'm moving a database to a different environment and after building and importing the data I realized that I forgot to set the counters above existing row counts.

This is on DB2 UDB V8 on Windows.

Any help would be appreciated thanks

ALTER TABLE Mytable ALTER COLUMN ID_Column restart with 12345

Andy

Thanks

Bob.