SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-35
V
examples of 2-410
histogram tables 2-403
row distribution 2-404
sample size 2-405
syntax diagram of 2-402
table row count 2-406
UPD_ABORT_ON_ERROR default 10-78
UPD_ORDERED default 10-72
UPD_SAVEPOINT_ON_ERROR
default 10-78
UPGRADE utility
considerations for 2-413
example of 2-415
output options for 2-413
UPPER function
examples of 8-201
syntax diagram of 8-201
UPSHIFT function
examples of 8-202
syntax diagram of 8-202
USER function
examples of 8-203
syntax diagram of 8-203
Utilities
DOWNGRADE 2-175
FASTCOPY 5-7
FIXRCB 5-7
FIXUP 5-8
GOAWAY 5-13
import 5-18
INFO 5-53
mxexportddl 5-55
MXGNAMES 5-59
mximportddl 5-67
privileges required to execute 5-2
RECOVER 2-311
VERIFY 5-79
V
Value expression 6-41
Value expressions
summary of 8-8
CASE (Conditional) expression 8-16
CAST expression 8-20
CURRENT_USER function 8-43
SESSION_USER function 8-168
USER function 8-203
VALUES statement
examples of 2-417
relationship to SELECT 2-417
syntax diagram of 2-417
VARCHAR data type 6-23
VARCHAR_PARAM_DEFAULT_SIZE
default 10-83
Variable-length character column 6-24
VARIANCE function
DISTINCT clause within 8-207
examples of 8-210
statistical definition of 8-207
syntax diagram of 8-207
VERIFY operation 5-79
VERSION_INFO function
example of 8-206
syntax diagram of 8-204
Views
CREATE VIEW statement 2-154
description of 6-115
DROP VIEW statement 2-193
insertable 2-160
relationship to tables 6-115
SQL/MP considerations 1-32
updatability requirements 2-160
VWS metadata table 10-35
VW_COL_TBL_COLS metadata
table 10-36
VW_COL_USAGE metadata table 10-36
VW_TBL_USAGE metadata table 10-36