ALLOW_UPD_DEL_INS_WITH_UR in macro DSN6SPRM
The ALLOW_UPD_DEL_INS_WITH_UR subsystem parameter specifies whether Db2 allows UPDATE, DELETE, or INSERT statements to be prepared with the isolation-clause attribute WITH UR.
The WITH UR isolation-clause is not allowed for UPDATE, INSERT, and DELETE statements. However, Db2 inadvertently allowed these statements to be prepared with the WITH UR isolation-clause attribute.
| Acceptable values: | NO, YES |
|---|---|
| Default: | NO |
| Online changeable: | Yes |
| Data sharing scope: | Group |
| DSNZPxxx: | DSN6SPRM ALLOW_UPD_DEL_INS_WITH_UR |
- NO
- Db2 disallows UPDATE, DELETE, or INSERT statements to be prepared with the isolation-clause attribute WITH UR. NO is the default value.
- YES
- Db2 allows UPDATE, DELETE, or INSERT statements to be prepared with the isolation-clause attribute WITH UR.
For best results, identify any applications that prepare UPDATE, DELETE, or INSERT statements with the WITH UR attribute and correct them. When such usage is encountered during execution of a PREPARE statement and ALLOW_UPD_DEL_INS_WITH_UR is set to YES, Db2 writes an incompatibility trace record, IFCID 376 with the function code 13 in QW0376FN. Use these trace records to identify and correct applications that are using the illegal SQL syntax.
