RE: disable constraints for dbload ??

Posted in 1997

Sujit Pal — 7 Jul 1997 20:03:22 -0400 — source: Informix-list mailing list archive (1991-1998)

Jens For Online databases: DROP CONSTRAINT constraint_name; dbloadALTER TABLE CREATE CONSTRAINT ...;(assuming that you have saved off the SQL for the constraints before you dropped them). For ODS databases: SET CONSTRAINT constraint_name DISABLED; dbloadSET CONSTRAINTS constraint_name ENABLED; HTH Sujit ---------- From: Jens Ebert[SMTP:ebert@mail.ppp.net] Sent: Monday, July 07, 1997 9:12 AM To: informix-list@rmy.emory.edu Subject: Q: disable constraints for dbload ?? Hi, to do the initial load of a Informix Online database I would like to use dbload but I need to disable constraint checking during this time (enable them afterwards). Any idea how to do this ??? Thank you, Jens