SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-54
COMMIT Option
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.
{ value [ SECOND[S] ] }
TIMEOUT { DEFAULT [ SECOND[S] ] }
{ NEVER }
sets the time allowed for lock requests to complete during the commit phase:
The default is TIMEOUT DEFAULT.
If the file system cannot grant a lock request from the operation within the specified
time, an error occurs and the operation performs the action specified in the
ONCOMMITERROR option.
ONCOMMITERROR commit-option
specifies a COMMIT option to take effect if a retryable error occurs during the
commit phase.
Retryable errors include file in use, lock request timeouts, resource unavailability,
and BEFORE/AFTER time window misses (error numbers 12, 40, 73, 1057, 1615,
1616, 1617, 1618, 1621, 1622, and 3001 to 3999).
A nonretryable error always causes SQL to cancel changes to the database and
terminate the operation, regardless 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.
The default is ONCOMMITERROR ROLLBACK WORK.
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).
value Wait the specified number of seconds (a number in the range
0.01 to 21474836.47); wait indefinitely if value is -1.
DEFAULT Wait 60 seconds.
NEVER Wait indefinitely. Your operation acquires the lock after all
concurrent locking transactions complete.