SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-34
U
READ COMMITTED 1-24
READ UNCOMMITTED 1-23
REPEATABLE READ 1-24
SERIALIZABLE 1-24
Transaction management
AUTOCOMMIT, effect of 1-17, 2-234
MODIFY TABLE use of 1-17
rules for DML statements 1-17
Transaction Management Facility
(TMF) 1-14
Transaction management statements
BEGIN WORK 2-44
COMMIT WORK 2-49
ROLLBACK WORK 2-253
SET TRANSACTION statement 2-301
Transactions 1-16
TRANSLATE function, syntax diagram
of 9-190
TRANSPOSE clause
cardinality of result 7-29
degree of result 7-28
examples of 7-30
SELECT statement use of 7-26
syntax diagram of 7-26
Triggers
ALTER TRIGGER statement 2-40
considerations 2-134
CREATE TABLE LIKE statement 2-112
CREATE TRIGGER statement 2-132
description 6-112
DROP TRIGGER statement 2-174
DUP utility 5-18
import utility 5-43
privileges 2-209
PURGEDATA utility 5-132
SET statement 2-290
SIGNAL SQLSTATE statement 2-306
TRIGGERS metadata table 10-33
TRIGGERS_CAT_USAGE metadata
table 10-35
TRIGGER_USED metadata table 10-35
TRIM function
examples of 9-192
typedef 3-67
U
UCASE 9-193
UCASE function
examples of 9-200
syntax diagram of 9-193
UCS2 character set 6-4
UDR_JAVA_OPTIONS default 10-82
UID 10-3
Union operation
associative, UNION ALL 2-278
columns, characteristics of 2-276
ORDER BY clause restriction 2-278
SELECT statement use of 2-270
UNIQUE constraint 6-9
UNLOCK TABLE statement
examples of 2-308
nonaudited tables and 2-308
syntax diagram of 2-308
UNREGISTER CATALOG command
examples of 2-309
syntax diagram of 2-309
Updatable view, requirements for 2-148
UPDATE access privilege
GRANT EXECUTE statement 2-211
GRANT statement 2-206
REVOKE EXECUTE statement 2-248
REVOKE statement 2-244
UPDATE statement
authorization requirements 2-315
conflicting updates 2-316
MXCI examples of 2-321
Publish/Subscribe examples of 2-326
SET clause 2-311
SET ON ROLLBACK clause 2-313
SET ROLLBACK clause 2-313