NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-48
COMMIT Option
See the examples that follow for the text of the warnings.
See CONTINUE Statement
on page C-65 for more information about user
responses.
{| 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 may 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 the following values as indicated in the syntax diagram:
If you specify a date but omit time, the time 00:00 is used.
If you specify a time with no date, the current date is used.
The default for AFTER time is the current date and time.
The default for BEFORE time is 00:00:2100.
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).
yyyy is a 4-digit year value.
hh is a 2-digit hour value (00, 01, ... , 23).
nn is a 2-digit minute value (00, 01, ... , 59).