If data linkage is applied to a table with a trigger defined by the user, inconsistency might occur between the databases because the trigger SQL is executed on the source database, and then after data linkage, the trigger is executed again on the target database.

Such a database inconsistency might occur in the following cases:

• A BEFORE trigger uses an assignment statement of a routine control SQL.
• An AFTER trigger is defined for the target table that is to be replicated.

If either of these conditions is satisfied, specify not_execute in the control_trigger operand in the import environment definition.

Note:

• If you define a file output statement of a routine control SQL statement in the AFTER trigger for the target table and specify not_execute in the control_trigger operand, data will not be output to the file.
• If a trigger is defined for the target table and HiRDB is accessed from within a function of the import information editing interface, the control_trigger operand is ignored in the import environment definition.

If CASCADE is specified as a referential constraint action for a table with a referential constraint defined, a trigger is defined for that table by HiRDB. If you will be applying data linkage to a table for which CASCADE is specified, make sure that the following conditions are satisfied:

Prerequisites

• In the import environment definition, specify not_execute in the control_reference_trigger operand.
• In the import environment definition, specify use in the check_pending operand.
• Apply data linkage to all tables for which a referential constraint is defined.
• The constraints for referenced tables and referencing tables are the same between the source and the target.

Limitations

A table for which a referential constraint is defined cannot be specified in an import information editing UOC routine.

If all these conditions are satisfied and a referential constraint is defined for tables that are subject to import processing, the corresponding tables are placed in check pending status. Execute the integrity check utility for each table and release the tables from check pending status.