NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-49
U
aborting R-24
and COMMIT WORK C-51
and SECURE S-10
audit fix-up phase W-6
AUTOWORK T-7
BEGIN WORK statement B-2
beginning B-2
commit phase W-7
committing C-51
concurrency summary of A-3
CONTINUE statement not
allowed C-66
control statements T-5
copying data from C-119
description of T-5
displaying status E-3
ending C-51
file recovery protection A-41
IDs T-11
IDs in catalogs T-11
initialization and load phase W-5
limit per table L-12
processing concepts T-5
utility
AUTOWORK T-7
LOAD L-33
PURGE P-31
PURGEDATA P-36
SECURE S-8
VERIFY V-4
TOTAL command T-9
Transaction ID, displaying current E-3
Transaction integrity, audited tables A-70
Transaction Management Facility
See TMF Transactions
TRANSIDS catalog table T-11
TRANSID, in TRANSIDS table T-11
TRIM function T-11
TRIM option, LOAD command L-25
TRUNC option, LOAD command L-30
Truncating display line S-42
Two-way partition split, ALTER TABLE
statement A-38
TYPE AS clause, DATETIME HOST
VA R IA B LE H-6
Type of object, displaying F-16
U
UNAVAILABLE PARTITION option,
CONTROL TABLE directive C-78
UNDERLINE_CHAR layout option R-12,
U-1
UNION columns S-25
UNION operator
and GROUP BY clause S-27
and HAVING clause S-27
and ORDER BY clause S-26
and shorthand views C-160, S-26
SELECT statement S-23
UNION ALL and associativity S-27
using S-25
UNIQUE clause, CREATE INDEX
statement C-134
UNIQUE index
and duplicate values C-134
and null values C-134
description of C-134
keys for I-9
UNIQUEENTRYCOUNT in COLUMNS
table C-41
UNIQUEVALUE, in INDEXES table I-10
UNITS specifier E-23
UNLOADIN option, LOAD command L-26
UNLOADOUT option, COPY
command C-116
UNLOCK TABLE statement
description of U-1
lock release summary L-46
Unnamed parameter P-13