SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-36
Q
Program format version (PFV) V-8
PROGRAM INVALIDATION P-28
PROGRAMCATALOGVERSION, in
PROGRAMS table P-32
PROGRAMFORMATVERSION, in
PROGRAMS table P-32
Programmatic SQL E-2
Programming language, description of E-2
PROGRAMNAME, in PROGRAMS
table P-31
Programs
ALTER PROGRAM statement A-27
altering security attributes A-27
catalog description of object in P-31
compiling from Guardian S-67
compiling from OSS C-176
dependent, effect of CLEANUP C-23
DROP statement D-65
dropping D-65, P-33
duplicating D-69, D-75
file recompilation P-28
HOSV V-8
invalid P-22
names G-7
ownership changes A-27
PCV V-8
PFV V-8
purging D-64
renaming A-27
Safeguard protection A-28
security changes A-27
using DEFINEs from D-31
versions of V-8
PROGRAMS catalog table
and program invalidation P-28, P-31
description of P-31
PROGRAM, parameter for FastSort Z-4
Prompts S-60
Protection views
AUDIT file attribute A-74
description of P-32, V-9
limit per table L-14
similarity S-55
PROTECTION, in VIEWS table V-10
PS Text Edit T-3
PUP utility U-17
PUP (Peripheral Utility Program) C-134
Purge
access S-14
date and time, changing A-32
objects D-63
PURGE command
and TMF P-34, P-35
description of P-33
LISTALL option P-34
SHADOWSONLY option P-34
PURGEDATA command
and TMF P-37, P-38
description of P-36
LISTALL option P-37
Q
Qualified column names C-46
Qualified fileset list Q-1
Quantified predicate Q-6
Queries
inner J-1
join J-1
outer J-1
Query execution plans P-22
Query optimization
CONTROL EXECUTOR directive C-73
CONTROL QUERY directive C-75
equijoin for parallel execution C-73
parallel processing C-73, C-74
using current statistics S-78