Re: Insert Cursors v/s DbLoad v/

h Chris Jenkins (chrisj@informix.com) wrote: : Hi Mark, : Denham.M@amstr.com wrote: : > Thanks for the info. I would expect that the manual is here and that someone has run off : > with it. : > : > One other question I thought of, do you know if the onpload respects all existing : > referential integrity constraints (like NOT NULL and unique indexes)? : > : > This seems like a stupid question to me, since I cannot think of a good reason why it : > should not take notice of constraints (other than performance). : > : > Mark : > MarkDenham@aol.com (home) : > Denham.M@amstr.com (work) : Yes, HPL respects all constraints. Depending on the load mode : (express/deluxe) : the exact way this is done differs somewhat. : Express : ------- : Constraints disabled during load and re-enabled afterwards. Any : violating data : copied to violations table. Manual cleanup required. : Deluxe : ------ : Data which violates constraints rejected (or filtered to violations : table) : during load. : More details in the docs. /q : Chris /q \\ \\ \\ ] /q