SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-71
Considerations—CONTINUE
{ COMMIT [WORK] options }
{ ROLLBACK [WORK] }
is a commit option that controls the start time for the final phase of the operation
and specifies the timeout period for lock requests and the handling of retryable
errors during the commit phase of the operation. The commit option can also direct
SQL to cancel changes made by the operation and terminate the operation.
For more information, see COMMIT Option on page C-52.
Considerations—CONTINUE

You cannot execute the CONTINUE statement within a user-defined transaction. If
you attempt to do so, SQL terminates the operation in effect and rolls back the
transaction, canceling all changes made to the database by either the operation or
the transaction.

A host language or SQLCI process that receives warning 1619 must respond with
a CONTINUE statement before terminating or taking any action that directly or
indirectly modifies a DEFINE. However, the process can execute other SQL
statements or SQLCI commands before executing a CONTINUE statement, except
for DDL statements or write-access utility operations on source or target objects of
the operation in progress.
If the process terminates or modifies a DEFINE before executing a CONTINUE
statement, the DDL operation in progress stops without being either committed or
canceled. The changes are not made (as they would be if the operation was
committed), and new SQL objects created by the operation are not removed (as
they would be if the operation was canceled).
If this scenario occurs, you must use CLEANUP to remove the new SQL objects
(or ask another user with access to the super ID to do so). If the operation was a
CREATE INDEX operation on a table with the AUDITCOMPRESS file attribute, you
might need to use ALTER TABLE to reset AUDITCOMPRESS.
An SQLCI process that uses a terminal as an IN file protects you from this situation
by not allowing any of these commands (which terminate the SQLCI process or
directly or indirectly modify DEFINEs) between error 1619 and a CONTINUE
statement:
The SQLCI process also behaves as if you specified SET BREAK_KEY OFF,
returning control to the previous Break key owner (usually TACL) if you press the
Break key. (This strategy allows you to return to TACL to execute other commands
before continuing the DDL operation, and then type PAUSE to return to SQLCI and
execute a CONTINUE statement.) In addition, SQLCI prompts with a
dedicated-operation-in-progress prompt (D>) instead of the normal SQLCI prompt
to remind you that an operation in progress is waiting for a CONTINUE statement.
ADD DEFINE ALTER DEFINE CATALOG DELETE DEFINE
EXIT SET DEFMODE SYSTEM VOLUME