NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-50
U
Unpartitioned table P-19
Unstructured files F-9
UNSTRUCTURED option
COPY command C-113
LOAD command L-22
Unsupported data types L-36
UPDATE operations
buffered C-77
file organization dependent F-8
UPDATE statement S-47, U-3
and scale S-47
column privileges S-68
lock release summary L-46
table privileges S-68
UPDATE STATISTICS statement
concurrent DML operations C-61
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-42
UPSHIFT option
COPY command C-113
LOAD command L-22
USAGES catalog table
and DISPLAY USE OF D-52
and program invalidation P-28
description of U-15
Use of, displaying D-51
USEDCATALOGNAME, in USAGES
table U-16
USEDOBJNAME, in USAGES table U-16
USEDOBJTYPE, in USAGES table U-16
User groups S-11, S-12
User IDs S-12
User number S-12
USER option, FILEINFO command F-10
USERID
in PROGRAMS table P-30
in TABLES table T-2
User-defined keys U-17
User-defined primary key
description of C-147
, U-17
length limit L-12
specifying C-147
USESQLNULLS option
COPY command C-113
LOAD command L-22
USING clause
CURRENT_TIMESTAMP function E-8
EXECUTE statement E-7
USING DESCRIPTOR clause
EXECUTE statement E-7
FETCH statement F-4
OPEN statement O-5
USING host variables clause O-5
USINGCATALOGNAME, in USAGES
table U-16
USINGOBJNAME, in USAGES table U-16
USINGOBJTYPE, in USAGES table U-16
Utilities
APPEND A-47
APPENDCANCEL A-51
APPENDRESTART A-53
CLEANUP C-19
CONVERT C-89
COPY C-109
description of U-17
DISPLAY USE OF D-51
DUP D-66
FILEINFO F-9
FILENAMES F-26
FILES F-27
FUP F-33
LOAD L-17