SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-35
P
PREPARE dynamic SQL P-5
PREPARE statement P-25
Prepared command
displaying S-51
resetting R-16
Primary access path E-16
PRIMARY KEY clause, CREATE TABLE
statement C-157
Primary keys
catalog description of K-1
description of P-27
for indexes I-9
length limit L-13
system-defined, data types S-90
updateable S-69
user-defined U-16
Primary partition P-19
PRIMARYEXT2, in FILES table F-28
PRIMARYEXT, in FILES table F-27
PRIMARYPARTITION, in PARTNS
table P-20
Print item headings, default D-50
Print items
concatenating C-63
conditional printing of I-1
default space before S-58
description of P-28
display formats A-60
headings D-48
overflow of field O-10
tab before printing D-49
width of VARCHAR text V-1
Print list output limit
BREAK FOOTING command B-6
BREAK TITLE command B-10
DETAIL command D-50
PAGE FOOTING command P-2
PAGE TITLE command P-4
REPORT FOOTING command R-2
REPORT TITLE command R-6
Print lists P-28
Printer, device width R-20
PRI, parameter for FastSort Z-4
Process
alter owner A-27, A-28
device width used R-20
Process Access ID (PAID) S-13
Process File Segment (PFS), limits L-10,
L-11
Process File Segment(PFS)
and DEFINEs D-27
increasing L-10
memory requirements L-10, L-11
Processing
concepts for TMF transactions T-6
control locking C-77
control parallel execution C-73, C-74
control query processing C-74
control table opens C-77
Processing rules
audited objects T-7
DDL and DML statements T-7
NO AUDIT attribute T-7
SQLCI T-8
PROCESSNAME, in TRANSIDS table T-11
PROGID attributes, in PROGRAMS
table P-31
PROGID attribute, alter owner A-27, A-28
PROGID file attribute
and security S-13
description of P-28
SECURE command S-9
Program catalog version (PCV) V-8
Program execution
authority for S-15
cost, in EXPLAIN report E-18, E-19,
E-20
displaying cost D-52
dynamic E-11
in EXPLAIN report E-14, E-18
Program file, validation P-28