SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-52
COMMIT Option
COMMIT Option
COMMIT is an option available on some potentially long-running DDL statements that
specifies the start time, the timeout period for lock requests, and the handling of
retryable errors for the final phase of the operation.
COMMIT also includes a ROLLBACK option that directs SQL to cancel changes to the
database and terminate the operation instead of proceeding with the final phase.
COMMIT is also an option on the CONTINUE statement. CONTINUE continues a DDL
operation that specifies COMMIT BY REQUEST and that is ready to enter its final
phase.
The final phase of a DDL operation (called the commit phase) always requires
exclusive locks on the objects involved. Using the COMMIT option to control the start
time, timeout period, and error handling for the final phase can minimize the
unavailability of applications that use the objects.
COMMIT [WORK]
directs SQL to begin the commit phase as specified by the other options. If you do
not specify other options, SQL uses:
COMMIT WORK WHEN READY
TIMEOUT DEFAULT
ONCOMMITERROR ROLLBACK WORK
{ [ WHEN READY ] }
{ [ ] }
{ COMMIT [WORK] [ [ BY ] REQUEST ] [ on-error ] }
{ [ ] }
{ [ {| AFTER time |} ] }
{ [ {| BEFORE time |} ] }
{ }
{ ROLLBACK [WORK] }
time is:
{ mmmbddbyyyy [, hh:nn ] }
{ ddbmmmbyyyy [, hh:nn ] }
{ hh:nn }
on-error is:
[ { value [ SECOND[S] ] } ]
[ TIMEOUT { DEFAULT [ SECOND[S] ] } ]
[ { NEVER } ]
[ ONCOMMITERROR commit-option ]