MOVE_TO_ARCHIVE_DEFAULT in macro DSN6SPRM
Specifies the default for the SYSIBMADM.MOVE_TO_ARCHIVE built-in global variable.
| Acceptable values: | N, E, Y |
|---|---|
| Default: | N |
| DSNZPxxx: | DSN6SPRM MOVE_TO_ARCHIVE_DEFAULT |
| Security parameter: | No |
- N
- Specifies that a delete of a row in an archive-enabled table will not result in storing a copy of the deleted row in the associated archive table.
- E
- Specifies that a delete of a row in an archive-enabled table will result in storing a copy of the deleted row in the associated archive table.
- Y
- Specifies that a delete of a row in an archive-enabled table will result in storing a copy of the deleted row in the associated archive table. Additionally, when the global variable is set to 'Y', an insert or update operation that specifies the archive-enabled table as the target of the statement will result in an error.