SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-47
T
Tables
address of EOF F-19
altering attributes A-32
attribute specification C-154
available space F-19
base T-1
catalog C-8
catalog description of T-2
clearing data from P-36
column limit L-6
COLUMNS C-46
COMMENTS C-51
CONSTRNT C-70
copying to an Enscribe file C-113
CREATE TABLE statement C-154
date-caused program
recompilation F-19
description of T-1
displaying C-123
DROP statement D-65
dropping P-33
duplicating D-69, D-74
expiration date, setting N-5
file statistics F-22
fragmented, updating statistics U-9
index dependencies C-148
inserting with check option I-17
joining S-30
limit on tables per query L-13
loading data into L-18
locking L-45, L-50
moving A-34
names G-7
organizations F-8
ownership change A-32
partitioned P-19
partitioning L-12
physical file attributes C-108
purging D-64
Tables (continued)
renaming A-32
row definition I-25
security change S-7
selecting from S-17
selectivity E-19
setting organization for C-158
similarity rules for S-55
specifying file attributes of C-160
temporary T-4, Z-17
transaction limit L-13
unlocking nonaudited U-1
unpartitioned P-19
updating rows of U-3
updating statistics for U-7
using ALTER TABLE statement A-29
versions V-7
view, limit L-6, L-8, L-13
view, security dependencies A-38
TABLES catalog table T-2
Tables partitions
adding A-35
dropping A-34
TABLETYPE, in TABLES table T-2
TAL language
and embedded SQL E-2
record definition, invoking I-26
TAPE DEFINEs D-33
Tapes, using with LOAD command L-34
TARGET option, DUP command D-73
TARGETDICT option, LOAD
command L-30
TARGETREC option, LOAD
command L-30
TEDIT command T-3
temporal scoping C-76
Temporary files, size limit L-13
Temporary tables
and DEFINE Z-17
description of T-4