NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-47
COMMIT Option
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
directs SQL to begin the commit phase as soon as the operation is ready to do so.
[ BY ] REQUEST
directs SQL to return warning 1619 when the operation is ready to commit and then
maintain its ready-to-commit state by performing audit fix-up work as needed until
the user responds with a CONTINUE statement that specifies a new COMMIT
option.
Unless you specified the COMMIT BY REQUEST in effect in an
ONCOMMITERROR option, SQL returns warning 1618 just before warning 1619.
If you specified the COMMIT BY REQUEST in effect in an ONCOMMITERROR
option, SQL returns the error that activated the ONCOMMITTERROR option just
before warning 1619.
{ [ 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 ]