MaxConflicts
When the insertion of any row within a multiple-row insert action violates a constraint or causes a conflict, the High-speed Apply Engine performs the actions defined by the conflict rule in the [InsertConflict] section that specifies a Code value of MultiRowConflict. The rule can be defined explicitly or by default values. For more information, see Codes-for-conflict-resolution-SQL-codes.
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [MultiRowInsert] |
Abbreviation | None |
Required? | No |
Valid values | Any integer value greater than or equal to 0 |
Default value | None |
Usage
Specify any integer value greater than or equal to zero. A value of zero indicates that the High-speed Apply Engine does not tolerate any conflicts and switches to single-row insert actions after it encounters the first conflict.
Be aware of the following points about this parameter:
- High-speed Apply Engine only supports multiple-row insert actions for mainframe targets.
- As it processes multiple-row insert actions, the High-speed Apply Engine uses the ATOMIC clause of the multiple-row INSERT statement. If an insert action for any row fails, all changes made to the target table by any of the insert actions are backed out (including changes made by successful insert actions).
- To simplify conflict processing, when High-speed Apply Engine performs a multiple-row insert action and encounters an SQL code other than 0 or -911, it resets the SQL code to -254 so that it can process the conflict rule defined by the Code value of MultiRowConflict in the [InsertConflict] section.