SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-279
Manage Partitions of Range Partitioned Tables and
Indexes
ROLLBACK [WORK]
specifies that the operation should be terminated. The effect is the same as issuing
a separate RECOVER command with the CANCEL option. ROLLBACK WORK
might only be specified in the last <on-error> clause.
ONCOMMITERROR commit-options
specifies what action SQL/MX should take if a retryable error occurs during
Commit Phase. Retryable errors include file in use, lock request timeouts, resource
unavailability, and BEFORE or AFTER time window misses.
A nonretryable error always causes SQL/MX to cancel changes to the database
and terminate the operation, no matter what you specify in the
ONCOMMITERROR option.
ONCOMMITERROR is recursive because it appears within a COMMIT option and
specifies another COMMIT option. You can specify up to three COMMIT options on
a single statement; specifying four or more causes an error.
RECLAIM | NO RECLAIM
specifies whether SQL/MX should automatically start ORSERV processes to
reclaim unused freespace in affected partitions (RECLAIM) or whether the user
must manually perform FUP RELOAD operations (NO RECLAIM). Partitions that
contain unused freespace have the UNRECLAIMEDSPACE (F) flag set in the file
label. Until the freespace is reclaimed, the flag remains set and any new MODIFY,
DUP, or BACKUP operation you attempt to perform on the object will fail with error
20290 (operation still in progress). DML operations can be performed on the
object, but all other operations will fail. If omitted, the default for range partitioned
objects is RECLAIM. The option will be ignored in situations where MODIFY does
not need to reclaim freespace.