SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-49
U
U
UNAVAILABLE PARTITION option,
CONTROL TABLE directive C-83
UNDERLINE_CHAR layout option R-10,
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-170
SELECT statement S-23
UNION ALL and associativity S-27
using S-25
UNIQUE clause, CREATE INDEX
statement C-143
UNIQUE index
and duplicate values C-143
and null values C-143
description of C-143
keys for I-9
UNIQUEENTRYCOUNT in COLUMNS
table C-46
UNIQUEVALUE, in INDEXES table I-10
UNITS specifier E-22
UNLOADIN option, LOAD command L-27
UNLOADOUT option, COPY
command C-121
UNLOCK TABLE statement
description of U-1
lock realease summary L-48
lock release summary L-48
Unnamed parameter P-13
Unpartitioned table P-19
Unstructured files F-8
UNSTRUCTURED option
COPY command C-117
LOAD command L-22
Unsupported data types L-36
unsupported Data types
COMPLEX L-36
LOGICAL L-36
UPDATE operations
buffered C-82
file organization dependent F-8
UPDATE statement
and scale S-46
and SETSCALE S-46
column privileges S-68
description of U-3
lock release summary L-48
table privileges S-68
UPDATE STATISTICS statement
concurrent DML operations C-65
description of U-7
Updateable primary keys S-69
UPGRADE CATALOG command U-11
UPGRADE SYSTEM CATALOG
command U-13
UPSHIFT clause, and data type D-3
UPSHIFT function U-14
UPSHIFT in COLUMNS table C-47
UPSHIFT option
COPY command C-117
LOAD command L-23
USAGES catalog table
and DISPLAY USE OF D-54
, D-55
and program invalidation P-29
description of U-15
Use of object, displaying D-54
USEDCATALOGNAME, in USAGES
table U-15
USEDOBJNAME, in USAGES table U-15
USEDOBJTYPE, in USAGES table U-15
User groups S-11, S-12
User IDs S-12
User number S-12
USER option, FILEINFO command F-9