Re: Insert Cursors v/s DbLoad v/

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. Chris