NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-52
W
CREATE VIEW statement C-156
definition text limit L-12
description of V-9
displaying physical characteristics F-9
DROP statement D-62
dropping P-33, P-34
duplicating D-66, D-73
grouped S-19, S-24
inserting with check option I-17
limit per table L-12
locking L-41
names G-7, V-9
ownership changes A-45, S-7
protection L-12, P-31
purging D-61
renaming A-45
row definition I-24
security changes A-45, S-7
selecting data from S-19, S-24
shorthand C-160, S-26, S-48
similarity S-56
specifying security attributes C-158
table security dependencies A-36
unlocking nonaudited U-1
versions V-7
VIEWS catalog table V-9
VIEWTEXT, in VIEWS table V-10
Virtual sequential block buffering (VSBB)
cursor operation C-86
description of C-63
effect on concurrency C-63
in EXPLAIN report E-19
syntax C-77
using C-84
VLM, parameter for FastSort Z-4
Volume
current default Z-3
displaying current default E-3
setting default V-10
VOLUME command V-10
VSBB
See Virtual sequential block buffering
W
WAIT IF LOCKED option, CONTROL
TABLE directive C-77
Wait time for lock requests C-79
Warnings
1618 C-47
, C-51, C-67, C-68, W-6
1619 C-47, C-51, C-65, C-66, C-67,
C-68
, W-6
8239 C-78
displaying S-42
WARNINGS option, SET SESSION
command S-42
WHENEVER directive W-1
WHERE clause
DELETE statement D-38
description of W-2
UPDATE statement U-3
WHERE CURRENT OF clause
DELETE statement D-38
UPDATE statement U-4
Widows, preventing in report D-46
Width of report L-50
Wild-card characters
in LIKE predicate L-3
in qualified filesets Q-2
WINDOW layout option R-12, W-2
WITH CHECK OPTION clause, CREATE
VIEW statement C-158
WITH DATA MOVEMENT clause
ALTER INDEX A-18
ALTER TABLE A-34
WITH HEADINGS clause, CREATE VIEW
statement C-158
WITH HELP TEXT clause, CREATE
VIEW statement C-159