Sorry about the easy and post but missing something easy I'm sure:

alter table amrobi2.testprod alter column column1 INTEGER generated always as identity (start with 10, increment by 12)

Could someone tell me what's wrong with this thing?

Thanks!

AMR

I doubt if you can change an 'ordinary' int column to an identity column

In any case, SQL Reference should help

Cheers
Sathyaram

The column is already an IDENTITY column. I need to LOAD data into a table and then restart the count at MAX(IDENTITY +1)...

Checked SQL reference but to no avail...

My SQL Reference says
ALTER TABLE amrobi2.testprod alter column column1 restart with 10

Very cool!!

Thank you - I had seen something a tad bit different...