Toad World® Forums

How to change the generation of DB2 identity


I’m doing a conversion of PER SQLServer 2005 to PER DB2 9.7.

My Identitiy column are generated in DB2 9.7 with the “GENERATED ALWAYS” instead of “GENERATED BY DEFAULT”.

I’m not able to find which script I can change to get the right keyword generated.

Any idea please?



Hi Hugues,

there is a new package that offers you a comfortable way how to change identity type of selected entities on workspace. Download custom package from:

Instructions to import the package: