Oninit cdi / Archive
Talk to an expert →

How to switch off constraints?

Posted in 2003

Topics: Versions, Editions & End-of-Life

Joachim Engel — — source: Usenet: comp.databases.informix

Hi, IMHO there is a command to switch off constraints for the purpose of import and so on. Anybody can help me? We are using IDS 7.31. Kind regards Joachim Engel.

↪ replying to Joachim Engel
Fernando Nunes — — source: Usenet: comp.databases.informix

Joachim Engel wrote: > Hi, > > IMHO there is a command to switch off constraints > for the purpose of import and so on. > > Anybody can help me? > > We are using IDS 7.31. > Yes. Check your SQL Syntax Guide. Something like "SET CONSTRAINTS FOR table DISABLED" (??) But please remember that re-enabling them can take very long (the engine will have to check them as if it was the first time). Regards.

↪ replying to Joachim Engel
Art S. Kagel — — source: Usenet: comp.databases.informix

On Tue, 07 Oct 2003 11:48:27 -0400, Joachim Engel wrote: Rather than disable the constraints which would require rechecking the entire hierarchy of rows, try suspending the constraint checks for the rows added/updated until the end of the transaction: begin work; set constraints all deferred; ---work commit work; -- All constraint checking of inserted/updated/deleted rows happens now with an error and forced rollback if the constraints fail. Art S. Kagel > Hi, > > IMHO there is a command to switch off constraints for the purpose of import > and so on. > > Anybody can help me? > > We are using IDS 7.31. > > > Kind regards > Joachim Engel.

Related threads

Glossary