SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-34
V
UPDATE statement
authorization requirements 2-255
conflicting updates 2-256
MXCI examples of 2-260
Publish/Subscribe examples of 2-262
SET clause 2-251
SET ON ROLLBACK clause 2-253
SET ROLLBACK clause 2-253
SKIP CONFLICT access 2-254
syntax diagram of 2-250
WHERE clause 2-254
UPDATE statement (embedded)
C examples of 2-261
COBOL examples of 2-261
positioned form 2-250
searched form 2-250
UPDATE STATISTICS statement
column groups 2-264
column lists 2-264
examples of 2-271
histogram tables 2-264
row distribution 2-265
sample size 2-266
syntax diagram of 2-263
table row count 2-267
UPD_ABORT_ON_ERROR default 10-69
UPD_ORDERED default 10-63
UPD_SAVEPOINT_ON_ERROR
default 10-69
UPPER function
examples of 9-167
syntax diagram of 9-167
UPSHIFT function
examples of 9-168
syntax diagram of 9-168
User aliases, for super IDs executing
privileged utilities 5-2
USER function
examples of 9-169
syntax diagram of 9-169
Utilities
DUP 5-4
FASTCOPY 5-11
FIXUP 5-17
GOAWAY 5-22
import 5-27
INFO 5-61
migrate 5-63
MODIFY 5-68
mxexportddl 5-88
MXGNAMES 5-92
mximportddl 5-99
POPULATE INDEX 5-108
privileges required to execute 5-2
PURGEDATA 5-111
RECOVER 5-115
VERIFY 5-117
V
Value expression 6-38
Value expressions
summary of 9-8
CASE (Conditional) expression 9-16
CAST expression 9-20
CURRENT_USER function 9-40
SESSION_USER function 9-143
USER function 9-169
VALUES statement
examples of 2-274
relationship to SELECT 2-274
syntax diagram of 2-274
VARCHAR data type 6-21, 6-22
VARCHAR_PARAM_DEFAULT_SIZE
default 10-73
Variable-length character column 6-22
VARIANCE function
DISTINCT clause within 9-170
examples of 9-173
statistical definition of 9-170