NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-35
P
increasing L-10
memory requirements L-9
PFV (program format version) V-8
Physical characteristics of object F-9
Physical primary keys
description of P-27
for indexes I-9
PHYSVOL clause
CREATE INDEX statement C-135
CREATE TABLE statement C-147
PICTURE 9 data syntax D-6
PICTURE X data syntax D-4
PICTURETEXT in COLUMNS table C-42
Plans
altered P-22
description of P-21
inoperable P-21
invalid P-22
operable P-21
optimal P-21
valid P-21
PL/1 S-69
POSITION function P-22
Precision
of expression results E-25
of numeric results E-25
PRECISION in COLUMNS table C-41
Predicates
BETWEEN B-3
comparison C-53
description of P-24
EXISTS E-12
IN I-3
in EXPLAIN report E-17
IS NULL N-6
LIKE L-1
multivalue C-55
NULL N-5
quantified Q-5
PREPARE dynamic SQL P-5
PREPARE statement P-24
Prepared command
displaying S-52
resetting R-18
Primary access path E-17
PRIMARY KEY clause, CREATE TABLE
statement C-147
Primary keys
catalog description of K-1
description of P-27
for indexes I-9
length limit L-12
system-defined, data types S-90
updateable S-69
user-defined U-17
Primary partition P-19
PRIMARYEXT, in FILES table F-28
PRIMARYPARTITION, in PARTNS
table P-20
Print item headings, default D-47
Print items
concatenating C-58
conditional printing of I-1
default space before S-58
description of P-27
display formats A-54
headings D-45
overflow of field O-9
tab before printing D-46
width of VARCHAR text V-1
Print list output limit
BREAK FOOTING command B-6
BREAK TITLE command B-11
DETAIL command D-47
PAGE FOOTING command P-2
PAGE TITLE command P-4
REPORT FOOTING command R-2
REPORT TITLE command R-8