NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-33
P
ALTER TABLE statement A-30
ALTER VIEW statement A-45
description of O-10
SECURE command S-9
Ownership
changing
methods for S-7
program A-25
table A-30
displaying D-53, F-13
of a file, defined S-14
Owner, generalized S-9, S-14
P
Packed record length F-17
PAD option
COPY command C-115
LOAD command L-22
Page
advancing to next D-46
conditional break D-45
length P-2
maximum in report P-1
size for PERUSE O-9
text at bottom of P-1
PAGE clause
DETAIL command D-46
report writer option R-12
PAGE FOOTING command
AS clause A-55
COMPUTE_TIMESTAMP
function C-57
CONCAT clause C-58
CURRENT_TIMESTAMP
function C-163
description of P-1
PAGE FOOTING, IF/THEN/ELSE
clause I-1
PAGE TITLE command
AS clause A-55
COMPUTE_TIMESTAMP
function C-57
CONCAT clause C-58
CURRENT_TIMESTAMP
function C-163
description of P-4
IF/THEN/ELSE clause I-1
PAGE_COUNT layout option P-1, R-11
PAGE_LENGTH layout option P-2, R-11
PAGE_NUMBER function P-3, R-12
PAID (Process Access ID) S-13
Parallel execution
in EXPLAIN report E-19
loading indexes C-136
query C-68, C-69
similarity, effect on S-55
PARALLEL EXECUTION clause, CREATE
INDEX statement C-136
PARALLEL EXECUTION option, LOAD
command L-31
Parallel index loading P-5
Parallel loading of index partitions C-136
Parallel query execution C-69
Parallel writes
compared to serial S-33
description of S-32
PARAM attribute, SAVE command S-2
Parameters
description P-12
displaying current value S-51
dynamic SQL and default data
types P-13
indicator I-11
name P-14
prepared commands P-24
resetting R-16
saving in a file S-2
setting value for S-36
specifying type of C-4, P-14