dbms ri

Allow Informix to manage referential integrity (instead of Uniface).

USYS$INF_PARAMS dbms ri

Use

Do not use this option when the connector is used together with Informix without logging.

Description

If you use this option, you allow Informix to handle referential integrity instead of Uniface. This option should be used during bulk load when Informix referential integrity controls are dropped so that the necessary cascading deletes on overflow rows can be performed.

When this option is not present, referential integrity is controlled by Uniface.

Note:  Informix does not handle referential integrity automatically. SQL script files need to be generated first with the Create Script utility. Execute these files to create referential integrity constraint, triggers, and stored procedures in the database to allow Informix to enforce referential integrity.