SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-53
COMMIT Option
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.
See the examples that follow for the text of the warnings.
For more information about user responses, see CONTINUE Statement on
page C-70.
{| AFTER time |}
{| BEFORE time |}
specifies that the operation start the commit phase only during the specified time
period in local civil time.
If the operation is ready to commit before AFTER time, the operation remains
ready to commit until AFTER time, performing audit fix-up work as needed to
remain ready to commit. If the operation becomes ready to commit after BEFORE
time, an error occurs and the operation performs the action specified in the
ONCOMMITERROR option.
AFTER time can be a time in the past but cannot be more than ten days in the
future.
BEFORE time must be a time in the future. If you specify both BEFORE time
and AFTER time, BEFORE time must be greater than AFTER time.
Specify time by using these values as indicated in the syntax diagram:
b is a required space.
mmm is a 3-character month value (JAN, FEB, MAR, APR, MAY, JUN, JUL,
AUG, SEP, OCT, NOV, or DEC).
dd is a 2-digit day value (01, 02, ... , 31).