SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-56
COMMIT WORK Statement
*** WARNING from SQL [1618]: The ALTER_TABLE statement
is ready to commit.
*** WARNING from SQL [1619]: To continue processing, please
enter a commit or rollback with a CONTINUE command.
D>
. The user can respond immediately or enter
. other commands first. (See
. CONTINUE Statement on page C-70
. for restrictions on other commands.)
D>CONTINUE ALTER_TABLE COMMIT AFTER 02:00
+> TIMEOUT NEVER
+> ONCOMMITERROR COMMIT BY REQUEST;
.
. Time passes until after 2:00 am,
. when SQL confirms the operation.
--- SQL operation complete.
>>
Notice that SQLCI prompts with “D>” (the dedicated-operation-in-progress prompt),
rather than the usual “>>”, while the ALTER TABLE operation executes in the
background, resumes the normal prompt after the operation finishes.
COMMIT WORK Statement
COMMIT WORK is a transaction control statement that ends a TMF transaction and
commits any changes to audited objects made during the transaction. COMMIT WORK
releases locks on audited and (unless you specify the AUDITONLY option) nonaudited
objects.
AUDITONLY
directs SQL to retain existing locks on nonaudited objects.
If your program holds locks on nonaudited objects and specifies AUDITONLY, the
program must explicitly use CLOSE, UNLOCK TABLE, or FREE RESOURCES to
close cursors and release locks.
In case of audited tables, COMMIT WORK AUDITONLY does not release locks on
these audited tables if any of the following conditions is true:

The plan is SERIAL and it does not have a SORT operation but had access
type set to BROWSE ACCESS.

The plan is SERIAL and it has a SORT operation (irrespective of the access
type).

The plan is PARALLEL (irrespective of the sort and access type).
COMMIT WORK [ AUDITONLY ]