Page 1 of 1
constraints disabled while loding the data to DB2 database
Posted: Mon Sep 08, 2008 10:44 pm
by vinodn
Hi,
Let us know how to disabled the constrints while loading the data to DB2 databse table,
Posted: Tue Sep 09, 2008 7:40 am
by chulett
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.
constraints disabled while loding the data to DB2 database
Posted: Thu Sep 11, 2008 8:44 am
by vinodn
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
Posted: Thu Sep 11, 2008 9:07 am
by chulett
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]