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

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-32
U
TRANSPOSE clause (continued)
degree of result 7-27
examples of 7-29
SELECT statement use of 7-25
syntax diagram of 7-25
Triggers
ALTER TRIGGER statement 2-26
considerations 2-98
CREATE TABLE LIKE statement 2-88
CREATE TRIGGER statement 2-96
description 6-111
DROP TRIGGER statement 2-132
DUP utility 5-8
import utility 5-21
privileges 2-143
PURGEDATA utility 5-73
SET statement 2-211
SIGNAL SQLSTATE statement 2-227
TRIGGERS metadata table 10-24
TRIGGERS_CAT_USAGE metadata
table 10-25
TRIGGER_USED metadata table 10-26
TRIM function
examples of 9-160
syntax diagram of 9-160
typedef 3-68
U
UCASE function
examples of 9-168
syntax diagram of 9-161
UCS2 character set 6-3
UDR_JAVA_OPTIONS default 10-64
UID 10-4
Union operation
associative, UNION ALL 2-201
columns, characteristics of 2-200
ORDER BY clause restriction 2-200
SELECT statement use of 2-193
UNIQUE constraint 6-8
UNLOCK TABLE statement
examples of 2-229
nonaudited tables and 2-229
syntax diagram of 2-229
UNREGISTER CATALOG command
examples of 2-230
syntax diagram of 2-230
Updatable view, requirements for 2-108
UPDATE access privilege
GRANT EXECUTE statement 2-145
GRANT statement 2-141
REVOKE EXECUTE statement 2-173
REVOKE statement 2-171
UPDATE statement
authorization requirements 2-236
conflicting updates 2-238
MXCI examples of 2-241
Publish/Subscribe examples of 2-243
SET clause 2-233
SET ON ROLLBACK clause 2-234
SET ROLLBACK clause 2-234
SKIP CONFLICT access 2-236
syntax diagram of 2-231
WHERE clause 2-235
UPDATE statement (embedded)
C examples of 2-242
COBOL examples of 2-243
positioned form 2-231
searched form 2-231
UPDATE STATISTICS statement
column groups 2-246
column lists 2-246
examples of 2-252
histogram tables 2-246
row distribution 2-247
sample size 2-247
syntax diagram of 2-245
table row count 2-248
UPD_ABORT_ON_ERROR default 10-62