SQL/MP Programming Manual for C

Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-10
P
Open System Services (OSS)
Accelerator 6-31
Binder program 6-31
C compilation 6-30
c89 utility 6-30
program development 6-28
shell escape character 6-29
SQL compiler 6-32
TACL DEFINEs 6-29
version considerations 6-28
Open tables, SQL 8-7
Opening tables and views 4-2
Operable execution plan 8-10
Operating system, Guardian
SQLCADISPLAY procedure 5-3
SQLCAFSCODE procedure 5-8
SQLCATOBUFFER procedure 5-14
Optimized execution plan
EXPLAIN PLAN report 6-27
SQL compiler function 6-13
statistics requirement 6-23
OUT file
C compiler 6-9
SQL compiler 6-14
Output host variable 2-1
Output variable
allocating space 10-33
displaying 10-33
dynamic SQL 10-12, 10-25
Overflow, stack space B-4
OWNER attribute, similarity check
rules 8-12
P
Parallel execution plans
automatic recompilation 8-3
similarity check 8-9
PARAM command, TACL
for SQL program file 7-2
PARAM command, TACL, with SQL
compiler 6-22
Parameter
dynamic SQL 10-11
indicator 10-17
unnamed 10-11
using a list 10-12
using in loop 10-13
value substitution 10-11
Partition
local, to maximize local autonomy C-1
similarity check rules for attributes 8-12
skipping unavailable C-3
Pascal, host language 1-1
Pathway environment
dynamic SQL server 10-36
error checking through requester 4-24
running C server process 7-6
Performance
automatic recompilation 8-5
INVOKE directive 2-19
memory considerations B-4
SQL cursor considerations 4-2
SQLSA statistics 9-13
PLAN option for EXPLAIN utility 6-16
PMSEARCHLIST TACL variable
Pointer, host variable 2-2
, 2-6
Pragmas, C compiler
NOXMEM B-2
RUN options 6-9
RUNNABLE 6-9, 6-12
SQL
description 3-2
SQLMEM B-2, B-5
SQL, specifying 6-7
SYSTYPE 6-9
XMEM B-5
XVAR B-5
PREFIX clause, INVOKE statement 2-23