SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-33
V
UPD_ORDERED default 10-57
UPD_SAVEPOINT_ON_ERROR
default 10-62
UPPER function
examples of 9-169
syntax diagram of 9-169
UPSHIFT function
examples of 9-170
syntax diagram of 9-170
User aliases, for super IDs executing
privileged utilities 5-2
USER function
examples of 9-172
syntax diagram of 9-172
Utilities
DUP 5-4
FIXUP 5-11
GOAWAY 5-15
import 5-20
INFO 5-36
MIGRATE 5-38
MODIFY 5-43
mxexportddl 5-59
MXGNAMES 5-61
mxtool 5-68
POPULATE INDEX 5-69
privileges required to execute 5-2
PURGEDATA 5-72
RECOVER 5-76
VERIFY 5-78
V
Value expression 6-39
Value expressions
summary of 9-8
CASE (Conditional) expression 9-18
CAST expression 9-22
CURRENT_USER function 9-41
SESSION_USER function 9-141
USER function 9-172
VALUES statement
examples of 2-254
relationship to SELECT 2-254
syntax diagram of 2-254
VARCHAR data type 6-20, 6-21
Variable-length character column 6-22
VARIANCE function
DISTINCT clause within 9-173
examples of 9-176
statistical definition of 9-173
syntax diagram of 9-173
VERIFY operation 5-78
Views
description of 6-111
insertable 2-109
relationship to tables 6-111
SQL/MP considerations 1-28
updatability requirements 2-108
VWS metadata table 10-27
VW_COL_TBLS metadata table 10-27
VW_COL_TBL_COLS metadata
table 10-28
VW_COL_USAGE metadata table 10-28
VW_TBL_USAGE metadata table 10-28
W
WEEK function
examples of 9-178
syntax diagram of 9-178
WHENEVER declaration
actions within 3-88
C examples of 3-89
COBOL examples of 3-89
conditions within 3-87
syntax diagram of 3-87