NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
W-4
WITH SHARED ACCESS OPTION
these must be preceded by an appropriate SELECT command and followed by a
LIST command to actually print a report.
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).
See NAME Option
on page N-2 for more information.
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.
See REPORT Option
on page R-3 for more information.
S> SET LAYOUT WINDOW SALARY;
Displays SALARY, NEW_SALARY,
and BONUS
S> SET LAYOUT WINDOW COL 2;
Displays LAST_NAME, SALARY,
NEW_SALARY, and BONUS
S> SET LAYOUT WINDOW TAB 44;
Displays BONUS (print position 44)
[| NAME operation-name |]
[| |]
[| [ TO collector ] |]
WITH SHARED ACCESS [| REPORT [ ON ] |]
[| [ OFF ] |]
[| |]
[| { COMMIT [WORK] commit-options } |]
[| { ROLLBACK [WORK] } |]