SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-34
U
Transaction management
AUTOCOMMIT, effect of 1-16, 2-222
MODIFY TABLE use of 1-16
rules for DML statements 1-16
Transaction Management Facility
(TMF) 1-13
Transaction management statements
BEGIN WORK 2-43
COMMIT WORK 2-48
ROLLBACK WORK 2-240
SET TRANSACTION statement 2-288
Transactions 1-15
TRANSLATE function, syntax diagram
of 9-185
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-135
CREATE TABLE LIKE statement 2-112
CREATE TRIGGER statement 2-132
description 6-112
DROP TRIGGER statement 2-167
DUP utility 5-12
import utility 5-37
privileges 2-201
PURGEDATA utility 5-121
SET statement 2-277
SIGNAL SQLSTATE statement 2-293
TRIGGERS metadata table 10-32
TRIGGERS_CAT_USAGE metadata
table 10-33
TRIGGER_USED metadata table 10-33
TRIM function
examples of 9-187
typedef 3-67
U
UCASE 9-188
UCASE function
examples of 9-195
syntax diagram of 9-188
UCS2 character set 6-4
UDR_JAVA_OPTIONS default 10-79
UID 10-3
Union operation
associative, UNION ALL 2-265
columns, characteristics of 2-263
ORDER BY clause restriction 2-265
SELECT statement use of 2-257
UNIQUE constraint 6-9
UNLOCK TABLE statement
examples of 2-295
nonaudited tables and 2-295
syntax diagram of 2-295
UNREGISTER CATALOG command
examples of 2-296
syntax diagram of 2-296
Updatable view, requirements for 2-146
UPDATE access privilege
GRANT EXECUTE statement 2-203
GRANT statement 2-198
REVOKE EXECUTE statement 2-236
REVOKE statement 2-232
UPDATE statement
authorization requirements 2-302
conflicting updates 2-303
MXCI examples of 2-307
Publish/Subscribe examples of 2-309
SET clause 2-298
SET ON ROLLBACK clause 2-300
SET ROLLBACK clause 2-300
SKIP CONFLICT access 2-301
syntax diagram of 2-297
WHERE clause 2-301
UPDATE statement (embedded)