Change the value of an IDENTITY Column

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

Hi ,
I have a column defined as identity column in a table , now during a batch load process, i have requirement to load a child table which has this identity column set as the Foreign Key

Now to make the load process simple , can i prevent DB2 from generating the sequence ID and generate it on my own during the Bulk Loading alone.

Do let me know if my query is not clear

sushanth bobby · Posted: Thu Dec 30, 2010 5:04 am

Cvishu,

Alter the table to remove the identity column.

Thanks,
Sushanth

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

Sushanth thanks for the resposnse, i want to do this process only during the mass loading during a end-of-day process , after that during my on-line insert i will require the IDENTITY column.

Hope am expressing my query clearly , pls let me know if am confusing.

Thanks

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

Hi ,
I just found that declaring a IDENTITY column with GENERATED BY DEFAULT instead of GENERATED ALWAYS option will resolve my problem .

Thanks all for your time .