ENFORCE
BMC AMI Load terminates if you specify ENFORCE with RESUME YES SHRLEVEL CHANGE.
ENFORCE tells BMC AMI Load whether to check for violations of Db2-defined constraints during load processing. If constraints exist, BMC AMI Utilities discard the rows that violate constraints. BMC AMI Load accepts the ENFORCE keywords even though BMC AMI Utilities do not currently support referential integrity. When BMC AMI Load encounters any referential integrity keywords, it issues a message indicating lack of support.
Specify the ENFORCE option keywords
CONSTRAINTS | When you specify CONSTRAINTS, BMC AMI Load checks the rows to be loaded for violations of Db2-defined check constraints, if any constraints exist. BMC AMI Load discards any rows that violate the constraints. If the first sub-parameter of the +ENFORCERI BMC AMI Load parameter is set to NO (the default), BMC AMI Load applies the Table Check Constraints only. If the first sub-parameter of +ENFORCERI is set to YES, BMC AMI Load applies the Table Check Constraints and issues an informational, warning, or error message depending upon the setting of the second sub-parameter (IGNORE, WARN, or ERROR) of +ENFORCERI. |
|---|---|
CONSTRAINTS | When you specify CONSTRAINTS with the INFORI keyword, BMC AMI Load checks the rows to be loaded for violations of Db2-defined check constraints, if any constraints exist. BMC AMI Load discards any rows that violate constraints. Due to the presence of the INFORI keyword, BMC AMI Load will also issue an informational, warning or error message depending upon the setting of the second sub-parameter (IGNORE, WARN, or ERROR) of +ENFORCERI. |
RI | When you specify RI with or without the INFORI keyword, BMC AMI Load will issue an informational, warning, or error message depending upon the setting of the second sub-parameter of +ENFORCERI (IGNORE, WARN, or ERROR). |
CHECK CONSTRAINTS | When you specify CHECK CONSTRAINTS, BMC AMI Load checks the rows to be loaded for violations of Db2-defined check constraints, if any constraints exist. BMC AMI Load discards any rows that violate the constraints. |
NO | When you specify NO, BMC AMI Load applies no constraints. |
The BMC AMI Load +ENFORCERI parameter, along with its subparameters, helps manage exactly how BMC AMI Load responds to the new ENFORCE keywords. For more information, see ENFORCERI. You can set the default for the ENFORCE option keywords using the BMC AMI Load +ENFORCERI parameter (from the //LODPARMS input) or you can also pre-customize the BMC AMI Load ENFORCERI values using the NGRISTRT configuration utility.