SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-35
V
SKIP CONFLICT access 2-314
syntax diagram of 2-310
WHERE clause 2-314
UPDATE statement (embedded)
C examples of 2-325
COBOL examples of 2-325
positioned form 2-310
searched form 2-310
UPDATE STATISTICS statement
column groups 2-328
column lists 2-328
examples of 2-335
histogram tables 2-328
row distribution 2-329
sample size 2-330
syntax diagram of 2-327
table row count 2-331
UPD_ABORT_ON_ERROR default 10-80
UPD_ORDERED default 10-74
UPD_SAVEPOINT_ON_ERROR
default 10-80
UPGRADE utility
considerations for 5-138
example of 5-140
output options for 5-138
UPPER function
examples of 9-201
syntax diagram of 9-201
UPSHIFT function
examples of 9-202
syntax diagram of 9-202
User aliases, for super IDs executing
privileged utilities 5-3
USER function
examples of 9-203
syntax diagram of 9-203
Utilities
DOWNGRADE 5-9
DUP 5-14
FASTCOPY 5-21
FIXRCB 5-29
FIXUP 5-30
GOAWAY 5-37
import 5-42
INFO 5-77
migrate 5-79
MODIFY 5-79
mxexportddl 5-103
MXGNAMES 5-107
mximportddl 5-115
POPULATE INDEX 5-127
privileges required to execute 5-3
PURGEDATA 5-130
RECOVER 5-134
VERIFY 5-142
V
Value expression 6-41
Value expressions
summary of 9-8
CASE (Conditional) expression 9-16
CAST expression 9-20
CURRENT_USER function 9-43
SESSION_USER function 9-168
USER function 9-203
VALUES statement
examples of 2-338
relationship to SELECT 2-338
syntax diagram of 2-338
VARCHAR data type 6-23
VARCHAR_PARAM_DEFAULT_SIZE
default 10-85
Variable-length character column 6-24
VARIANCE function
DISTINCT clause within 9-207
examples of 9-210
statistical definition of 9-207
syntax diagram of 9-207
VERIFY operation 5-142