Comparing files with unique keys, triggers, and constraints - assure_mimix - 10.0

Assure MIMIX Administrator Reference

Product type
Software
Portfolio
Integrate
Product family
Assure
Product
Assure MIMIX™ Software
Version
10.0
Language
English
Product name
Assure MIMIX
Title
Assure MIMIX Administrator Reference
Copyright
2023
First publish date
1999
ft:lastEdition
2024-05-07
ft:lastPublication
2024-05-07T13:36:02.962500

If members being repaired have unique keys, active triggers, or constraints, special care should be taken. An updated or insert repair action that results in one or more duplicate key exceptions automatically results in the deletion of records with duplicate keys.

Note: The records that could be deleted include those outside the subset of records being compared. Deletion of records with duplicate keys is not recorded in the outfile statistics.

If triggers are enabled, any compare or repair action causes the applicable trigger to be invoked. Triggers should be disabled if this action is not desired by the user. When a compare is specified, read triggers are invoked as records are read. If repair action is specified, update, insert, and delete triggers are invoked as records are repaired.

Table 69 describes the interaction of triggers with CMPFILDTA repair and active processing.

Attention: If an attempt is made to use one of the unsupported situations listed in Table 69, the job that invokes the trigger will end abruptly. You will see a CEE0200 information message in the job log shortly before the job ends. You may also see an MCH2004 message.

CMPFILDTA and trigger support

Trigger type

Trigger activation group (ACTGRP)

CMPFILDTA -

Repair on system (REPAIR)

CMPFILDTA -

Process while active (ACTIVE)

CMPFILDTA

support

Read

*NEW

Any value

Any value

Not supported

Read

NAMED or *CALLER

Any value

Any value

Supported

Update, insert, and delete

*NEW

*NONE

Any value

Supported

Update, insert, and delete

*NEW

Any value other than *NONE

*NO

Not supported

Update, insert, and delete

*NEW

Any value other than *NONE

*YES

Supported

Update, insert, and delete

NAMED or *CALLER

Any value

Any value

Supported