SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-10
P
P
PAGES option, SQL directive 3-36
Pages, allocation of 5-34
PARAM command, TACL
for SQL program file 5-30
with SQL compiler 5-13
Parameters, TACL
in RUN command for SQL object
file 5-30
Parameter, SQL
dynamic SQL default data types 2-26
in dynamic SQL operations 2-23
indicator 2-25
syntax for 2-23
unnamed 2-23
using a list 2-24
using in a loop 2-25
Partition, local
using to maximize local autonomy 5-28
Pascal programming language 1-1
Pathway, dynamic SQL server 7-3
Performance, NonStop SQL 5-24, 5-34
getting from SQLSA 6-10
PLAN option for EXPLAIN utility 5-8
Pointer, structure
as host variable 2-9
PRECISION field
data type literals for 6-18
in SQLDA structure 7-5
PREFIX clause
with INVOKE statement 3-29
PREPARE statement, SQL 3-30, 7-10,
7-15
Process file segment (PFS) 5-31
Program development, C
using mixed-version features D-12
Program development, TAL
for release C10 D-10
overview of 1-2
using mixed-version features D-11
Program development, TAL (continued)
using Version 2 features for C10
program D-8
Program execution
for SQL program file 5-30
using TACL DEFINEs 5-31
Program size, estimating 5-32
PROGRAMS tables 5-10
Program, dynamic SQL example C-1
Program, TAL
using embedded SQL 1-2
Propagating TACL DEFINEs 5-32
PUTPOOL system procedure 7-14
Q
Query
decomposition in EXPLAIN plan 5-17
using a parameter with 2-23
Question mark (?)
as unnamed parameter 2-23
Quotes
double (") in SQL statements 3-2
Quotes (’) in SQL statements 3-2
R
READ system procedure 1-3
Reading a row
using FETCH statement 3-18
READUPDATE system procedure 7-3
RECOMPILE option, SQL compiler 5-9,
5-24
RECOMPILEALL option, SQL
compiler 5-10
, 5-25
RECOMPILEONDEMAND option, SQL
compiler 5-10
, 5-25
Referential integrity
enforcing E-1
example of E-3
managing E-2
Relational database management system
(RDBMS) 1-1