SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-35
V
C examples of 2-308
COBOL examples of 2-308
positioned form 2-297
searched form 2-297
UPDATE STATISTICS statement
column groups 2-311
column lists 2-311
examples of 2-318
histogram tables 2-311
row distribution 2-312
sample size 2-313
syntax diagram of 2-310
table row count 2-314
UPD_ABORT_ON_ERROR default 10-77
UPD_ORDERED default 10-72
UPD_SAVEPOINT_ON_ERROR
default 10-77
UPGRADE utility 5-127
considerations for 5-127
example of 5-129
output options for 5-127
UPPER function
examples of 9-196
syntax diagram of 9-196
UPSHIFT function
examples of 9-197
syntax diagram of 9-197
User aliases, for super IDs executing
privileged utilities 5-3
USER function
examples of 9-198
syntax diagram of 9-198
Utilities
DOWNGRADE 5-5
DUP 5-8
FASTCOPY 5-15
FIXRCB 5-24
FIXUP 5-25
GOAWAY 5-31
import 5-36
INFO 5-70
migrate 5-72
MODIFY 5-72
mxexportddl 5-96
MXGNAMES 5-100
mximportddl 5-108
POPULATE INDEX 5-117
privileges required to execute 5-3
PURGEDATA 5-120
RECOVER 5-124
UPGRADE 5-127
VERIFY 5-131
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-163
USER function 9-198
VALUES statement
examples of 2-321
relationship to SELECT 2-321
syntax diagram of 2-321
VARCHAR data type 6-23
VARCHAR_PARAM_DEFAULT_SIZE
default 10-82
Variable-length character column 6-24
VARIANCE function
DISTINCT clause within 9-202
examples of 9-205
statistical definition of 9-202
syntax diagram of 9-202
VERIFY operation 5-131
VERSION_INFO function
example of 9-201
syntax diagram of 9-199