Re: Turning off constraint checking

Posted in 2000

Obnoxio The Clown — Thu, 31 Aug 2000 10:01:47 BST — source: Informix-list mailing list archive (1991-1998)

SET CONSTRAINTS DISABLED; SET INDEXES DISABLED; ? From: "Hale, Robert [CREST:5K46:EXCH]" <rhale@americasm05.nt.com> > > a couple of years ago, I had to load a large data set into an Informix >7.? database. At the time, there was a command that could be used to >turn all constraint checking off for the entire database or a set of >tables. I've checked my notes, but cannot find the syntax for this >command anywhere. Does anyone remember off hand what the command is to >turn constraint checking off for a table? > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.