SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
W-4
WITH SHARED ACCESS OPTION
WITH SHARED ACCESS OPTION
WITH SHARED ACCESS is an option available on some DDL statements that
specifies that the DDL operation is to allow concurrent read-write DML access and
read-only utility access to the objects on which it operates during all but the final phase
of the operation.
DDL statements that include the WITH SHARED ACCESS option initiate potentially
long-running operations that prohibit concurrent INSERT, DELETE, UPDATE, and
utility operations unless you explicitly specify WITH SHARED ACCESS.
NAME operation-name
specifies an SQL identifier as the name of the operation.
If you omit the NAME option, the name of the operation is the first two words of the
statement that initiated the operation concatenated by an underscore (for example,
CREATE_INDEX).
For more information, see NAME Option on page N-2.
REPORT [ TO collector | ON | OFF ]
controls EMS reporting for the operation.
Omitting the option entirely is equivalent to specifying REPORT ON and sends
event messages for the operation to $0, the default EMS collector. Specifying
REPORT without an option is equivalent to specifying REPORT OFF and
suppresses event messages for the operation.
For more information, see REPORT Option
on page R-3.
{ COMMIT [WORK] commit-options }
{ ROLLBACK [WORK] }
specifies the start time, the timeout period for lock requests, and the handling of
retryable errors for the commit phase of the operation. The default is,
[| NAME operation-name |]
[| |]
[| [ TO collector ] |]
WITH SHARED ACCESS [| REPORT [ ON ] |]
[| [ OFF ] |]
[| |]
[| { COMMIT [WORK] commit-options } |]
[| { ROLLBACK [WORK] } |]