SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-35
V
UPDATE STATISTICS
statement (continued)
column lists 2-267
examples of 2-274
histogram tables 2-267
row distribution 2-268
sample size 2-269
syntax diagram of 2-266
table row count 2-270
UPD_ABORT_ON_ERROR default 10-74
UPD_ORDERED default 10-69
UPD_SAVEPOINT_ON_ERROR
default 10-74
UPGRADE utility 5-121
considerations for 5-121
example of 5-123
output options for 5-121
UPPER function
examples of 9-174
syntax diagram of 9-174
UPSHIFT function
examples of 9-175
syntax diagram of 9-175
User aliases, for super IDs executing
privileged utilities 5-2
USER function
examples of 9-176
syntax diagram of 9-176
Utilities
DOWNGRADE 5-4
DUP 5-7
FASTCOPY 5-14
FIXRCB 5-20
FIXUP 5-21
GOAWAY 5-26
import 5-31
INFO 5-65
migrate 5-67
MODIFY 5-72
mxexportddl 5-92
Utilities (continued)
MXGNAMES 5-96
mximportddl 5-103
POPULATE INDEX 5-112
privileges required to execute 5-2
PURGEDATA 5-115
RECOVER 5-119
UPGRADE 5-121
VERIFY 5-124
V
Value expression 6-41
Value expressions
summary of 9-8
CASE (Conditional) expression 9-16
CAST expression 9-20
CURRENT_USER function 9-40
SESSION_USER function 9-150
USER function 9-176
VALUES statement
examples of 2-277
relationship to SELECT 2-277
syntax diagram of 2-277
VARCHAR data type 6-23
VARCHAR_PARAM_DEFAULT_SIZE
default 10-79
Variable-length character column 6-24
VARIANCE function
DISTINCT clause within 9-180
examples of 9-183
statistical definition of 9-180
syntax diagram of 9-180
VERIFY operation 5-124
VERSION_INFO function
example of 9-179
syntax diagram of 9-177
Views
CREATE VIEW statement 2-111
description of 6-112
DROP VIEW statement 2-137