SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-34
V
UPDATE statement (continued)
SKIP CONFLICT access 2-230
syntax diagram of 2-226
WHERE clause 2-230
UPDATE statement (embedded)
C examples of 2-237
COBOL examples of 2-237
positioned form 2-226
searched form 2-226
UPDATE STATISTICS statement
column groups 2-240
column lists 2-240
examples of 2-246
histogram tables 2-240
row distribution 2-241
sample size 2-241
syntax diagram of 2-239
table row count 2-242
UPD_ABORT_ON_ERROR default 10-64
UPD_ORDERED default 10-59
UPD_SAVEPOINT_ON_ERROR
default 10-64
UPPER function
examples of 9-163
syntax diagram of 9-163
UPSHIFT function
examples of 9-164
syntax diagram of 9-164
User aliases, for super IDs executing
privileged utilities 5-2
USER function
examples of 9-165
syntax diagram of 9-165
Utilities
DUP 5-4
FIXUP 5-11
GOAWAY 5-16
import 5-21
INFO 5-40
migrate 5-42
Utilities (continued)
MODIFY 5-47
mxexportddl 5-63
MXGNAMES 5-65
mxtool 5-72
POPULATE INDEX 5-73
privileges required to execute 5-2
PURGEDATA 5-76
RECOVER 5-80
VERIFY 5-82
V
Value expression 6-37
Value expressions
summary of 9-8
CASE (Conditional) expression 9-16
CAST expression 9-20
CURRENT_USER function 9-37
SESSION_USER function 9-139
USER function 9-165
VALUES statement
examples of 2-248
relationship to SELECT 2-248
syntax diagram of 2-248
VARCHAR data type 6-20, 6-21
VARCHAR_PARAM_DEFAULT_SIZE
default 10-68
Variable-length character column 6-21
VARIANCE function
DISTINCT clause within 9-166
examples of 9-169
statistical definition of 9-166
syntax diagram of 9-166
VERIFY operation 5-82
Views
CREATE VIEW statement 2-104
description of 6-108
DROP VIEW statement 2-130
insertable 2-108