SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-33
U
Transaction isolation levels (continued)
REPEATABLE READ 1-22
SERIALIZABLE 1-22
Transaction management
AUTOCOMMIT, effect of 1-15, 2-157
MODIFY TABLE use of 1-15
rules for DML statements 1-15
Transaction Management Facility
(TMF) 1-12
Transaction management statements
BEGIN WORK 2-25
COMMIT WORK 2-30
ROLLBACK WORK 2-172
SET TRANSACTION statement 2-218
Transactions 1-14
TRANSLATE function, syntax diagram
of 9-152
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-24
considerations 2-97
CREATE TABLE LIKE statement 2-87
CREATE TRIGGER statement 2-95
description 6-108
DROP TRIGGER statement 2-129
DUP utility 5-8
import utility 5-22
privileges 2-140
PURGEDATA utility 5-77
SET statement 2-207
SIGNAL SQLSTATE statement 2-222
TRIGGERS metadata table 10-25
TRIGGERS_CAT_USAGE metadata
table 10-26
TRIGGER_USED metadata table 10-27
TRIM function
examples of 9-154
syntax diagram of 9-154
typedef 3-66
U
UCASE function
examples of 9-162
syntax diagram of 9-155
UCS2 character set 6-3
UDR_JAVA_OPTIONS default 10-66
UID 10-4
Union operation
associative, UNION ALL 2-197
columns, characteristics of 2-196
ORDER BY clause restriction 2-197
SELECT statement use of 2-189
UNIQUE constraint 6-8
UNLOCK TABLE statement
examples of 2-224
nonaudited tables and 2-224
syntax diagram of 2-224
UNREGISTER CATALOG command
examples of 2-225
syntax diagram of 2-225
Updatable view, requirements for 2-107
UPDATE access privilege
GRANT EXECUTE statement 2-141
GRANT statement 2-138
REVOKE EXECUTE statement 2-169
REVOKE statement 2-167
UPDATE statement
authorization requirements 2-231
conflicting updates 2-232
MXCI examples of 2-236
Publish/Subscribe examples of 2-238
SET clause 2-227
SET ON ROLLBACK clause 2-229
SET ROLLBACK clause 2-229