alter the identity column to update value in Db2

ALTER TABLE RECEIPT ALTER COLUMN RECEIPT_NUMBER DROP IDENTITY
GO
update GDT.RECEIPT set RECEIPT_NUMBER=1 where RECEIPT_NUMBER=2
GO
SELECT     MAX(RECEIPT_NUMBER)  FROM     GDT.RECEIPT
go
ALTER TABLE  RECEIPT ALTER COLUMN RECEIPT_NUMBER SET GENERATED BY DEFAULT as identity( START WITH 32331 INCREMENT BY 1 CACHE 20)
GO

~ by Ramchandra on November 19, 2008.