Constraints

To maintain consistent behavior between the IQ main and RLV stores, constraints are checked during load, insert and update statements.

Primary key and unique indexes are supported, but require additional memory and processing during the modification of RLV-enabled tables. To optimize performance while modifying RLV-enabled table, keep these index types to a minimum. Referential integrity and foreign key constraints are not supported on RLV-enabled tables.

Detected constraint violations cause DML commands to fail. The load command provides an IGNORE CONSTRAINT clause which allows a specified number of constraint violations to be reported and ignored before the load command is aborted.

• Table Constraints
  RLV store loads use the same table constraint evaluation mechanism as IQ main store loads, and have identical performance characteristics with regards to table constraint evaluation.
• Unique and Primary Key Constraints
  Primary key and unique constraints are supported for RLV store loads, inserts and updates, in a specific way.
• Referential Integrity Constraints
  Referential integrity constraints are not supported in the RLV store.