Hi guys,
I am new to DB2. I am working on the project of data migration. we have a requirement of data migration on everyday basis.

Table yyyy which has auto generation column like

CREATE TABLE yyyy (acc_Number INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE),....

my question is, I wanted to disable/drop the auto generation key on "acc_Number" before doing insertion. Then after insertion i have to enable/recreate the generated key on the same "acc_Number" field.

Reply to this posting is highly appreciated.

with regards,
Bala

Refer to SET INTEGRITY statement in SQL Reference ..

Your statement may look like

SET INTEGRITY FOR yyyy OFF

HTH

Cheers
Sathyaram