SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-34
U
Transaction management statements
BEGIN WORK 2-52
COMMIT WORK 2-57
ROLLBACK WORK 2-328
SET TRANSACTION statement 2-376
Transactions 1-15
TRANSLATE function, syntax diagram
of 8-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-48
considerations 2-146
CREATE TABLE LIKE statement 2-124
CREATE TRIGGER statement 2-144
description 6-115
DROP TRIGGER statement 2-192
DUP utility 2-198
import utility 5-19
privileges 2-244
SET statement 2-365
SIGNAL SQLSTATE statement 2-381
TRIGGERS metadata table 10-32
TRIGGERS_CAT_USAGE metadata
table 10-34
TRIGGER_USED metadata table 10-34
TRIM function
examples of 8-192
typedef 3-67
U
UCASE 8-193
UCASE function
examples of 8-200
syntax diagram of 8-193
UCS2 character set 6-4
UDR_JAVA_OPTIONS default 10-80
UID 10-3
Union operation
associative, UNION ALL 2-353
columns, characteristics of 2-351
ORDER BY clause restriction 2-353
SELECT statement use of 2-345
UNIQUE constraint 6-9
UNLOCK TABLE statement
examples of 2-383
nonaudited tables and 2-383
syntax diagram of 2-383
UNREGISTER CATALOG command
examples of 2-384
syntax diagram of 2-384
Updatable view, requirements for 2-160
UPDATE access privilege
GRANT EXECUTE statement 2-247
GRANT statement 2-241
REVOKE EXECUTE statement 2-323
REVOKE statement 2-317
UPDATE statement
authorization requirements 2-390
conflicting updates 2-391
MXCI examples of 2-396
Publish/Subscribe examples of 2-401
SET clause 2-386
SET ON ROLLBACK clause 2-388
SET ROLLBACK clause 2-388
SKIP CONFLICT access 2-389
syntax diagram of 2-385
WHERE clause 2-389
UPDATE statement (embedded)
C examples of 2-400
COBOL examples of 2-400
positioned form 2-385
searched form 2-385
UPDATE STATISTICS statement
column groups 2-403
column lists 2-403