SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-33
U
Timeout values (continued)
static
lock timeout 2-51, 10-48
stream timeout 2-36, 10-72
Transaction access modes 1-21
Transaction control, statements for 2-3
Transaction isolation levels
READ COMMITTED 1-22
READ UNCOMMITTED 1-21
REPEATABLE READ 1-22
SERIALIZABLE 1-22
Transaction management
AUTOCOMMIT, effect of 1-15, 2-180
MODIFY TABLE use of 1-15
rules for DML statements 1-15
Transaction Management Facility
(TMF) 1-12
Transaction management statements
BEGIN WORK 2-27
COMMIT WORK 2-33
ROLLBACK WORK 2-195
SET TRANSACTION statement 2-241
Transactions 1-14
TRANSLATE function, syntax diagram
of 9-156
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-26
considerations 2-104
CREATE TABLE LIKE statement 2-93
CREATE TRIGGER statement 2-101
description 6-109
DROP TRIGGER statement 2-135
DUP utility 5-8
import utility 5-28
Triggers (continued)
privileges 2-163
PURGEDATA utility 5-112
SET statement 2-230
SIGNAL SQLSTATE statement 2-246
TRIGGERS metadata table 10-26
TRIGGERS_CAT_USAGE metadata
table 10-26
TRIGGER_USED metadata table 10-28
TRIM function
examples of 9-158
syntax diagram of 9-158
typedef 3-67
U
UCASE function
examples of 9-166
syntax diagram of 9-159
UCS2 character set 6-4
UDR_JAVA_OPTIONS default 10-71
UID 10-4
Union operation
associative, UNION ALL 2-220
columns, characteristics of 2-218
ORDER BY clause restriction 2-220
SELECT statement use of 2-212
UNIQUE constraint 6-9
UNLOCK TABLE statement
examples of 2-248
nonaudited tables and 2-248
syntax diagram of 2-248
UNREGISTER CATALOG command
examples of 2-249
syntax diagram of 2-249
Updatable view, requirements for 2-114
UPDATE access privilege
GRANT EXECUTE statement 2-164
GRANT statement 2-161
REVOKE EXECUTE statement 2-192
REVOKE statement 2-190