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

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-34
U
Transaction management
statements (continued)
COMMIT WORK 2-31
ROLLBACK WORK 2-196
SET TRANSACTION statement 2-244
Transactions 1-14
TRANSLATE function, syntax diagram
of 9-163
TRANSPOSE clause
cardinality of result 7-28
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-25
considerations 2-104
CREATE TABLE LIKE statement 2-92
CREATE TRIGGER statement 2-101
description 6-112
DROP TRIGGER statement 2-136
DUP utility 5-11
import utility 5-32
privileges 2-164
PURGEDATA utility 5-116
SET statement 2-233
SIGNAL SQLSTATE statement 2-249
TRIGGERS metadata table 10-28
TRIGGERS_CAT_USAGE metadata
table 10-30
TRIGGER_USED metadata table 10-30
TRIM function
examples of 9-165
syntax diagram of 9-165
typedef 3-67
U
UCASE function
examples of 9-173
syntax diagram of 9-166
UCS2 character set 6-4
UDR_JAVA_OPTIONS default 10-76
UID 10-3
Union operation
associative, UNION ALL 2-221
columns, characteristics of 2-219
ORDER BY clause restriction 2-221
SELECT statement use of 2-213
UNIQUE constraint 6-9
UNLOCK TABLE statement
examples of 2-251
nonaudited tables and 2-251
syntax diagram of 2-251
UNREGISTER CATALOG command
examples of 2-252
syntax diagram of 2-252
Updatable view, requirements for 2-115
UPDATE access privilege
GRANT EXECUTE statement 2-165
GRANT statement 2-162
REVOKE EXECUTE statement 2-193
REVOKE statement 2-191
UPDATE statement
authorization requirements 2-258
conflicting updates 2-259
MXCI examples of 2-263
Publish/Subscribe examples of 2-265
SET clause 2-254
SET ON ROLLBACK clause 2-256
SET ROLLBACK clause 2-256
SKIP CONFLICT access 2-257
syntax diagram of 2-253
WHERE clause 2-257
UPDATE statement (embedded)
C examples of 2-264
COBOL examples of 2-264
positioned form 2-253
searched form 2-253
UPDATE STATISTICS statement
column groups 2-267