constraints disabled while loding the data to DB2 database

vinodn · Post by **vinodn** » Mon Sep 08, 2008 10:44 pm

Hi,

Let us know how to disabled the constrints while loading the data to DB2 databse table,

chulett · Post by **chulett** » Tue Sep 09, 2008 7:40 am

You'd need to have permission to do so and then issue the DDL in the OPEN tab of the stage. I assume. And then attempt to enable them again afterwards.

vinodn · Post by **vinodn** » Thu Sep 11, 2008 8:44 am

Thanks chulett for your's response,

we had the permissions to disables the constraints,but we are using the DB2 load stage to load the data,

Let me know how to disabled the constraints, which property needs to be set in DB2 load stage

chulett · Post by **chulett** » Thu Sep 11, 2008 9:07 am

Don't do DB2, so no clue. Must be an OPEN or BEFORE SQL area, if not perhaps you'd need to do it as separate steps / routines and leverage a sequence job. [shrug]