SQL/MP Programming Manual for C

Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-11
Q
PREPARE statement
dynamic SQL compilation 10-25
PREPARE statement, SQL compilation
errors 6-23
Primary key in SELECT statement 4-6
Procedures
See SQL/MP system procedures
process access ID (PAID)
DECLARE CURSOR statement 4-18
DELETE statement 4-23
FETCH statement 4-20
OPEN statement 4-19
privileges 7-1
SELECT statement 4-21
SQL cursor requirements 4-16
UPDATE statement 4-22
Process file segment (PFS) 7-2
Process identification numbers (PIN)
description 7-4
high and low 7-4
Processes, concurrent 7-4
PROCESS_CREATE_ procedure
authority 7-1
memory B-5
programmatic commands 7-5
PROGID attribute 7-1
Program catalog version (PCV)
CHECK options 6-18
, 8-10
definition 6-37
OSS program file 6-33
similarity check 8-11
Program development, C
advantages of INVOKE directive 2-19
automatic recompilation
dependencies 8-3
overview 1-1
Program file, SQL
binding object file 6-11
execution 7-1
SQL compilation 6-12
Program file, SQL (continued)
TACL DEFINEs 7-2
TACL RUN command 7-3
Program format version (PFV)
CHECK options 6-18, 8-10
definition 6-37
OSS program file 6-33
similarity check 8-11
SQL executor 7-7
Program object file
See Program file, SQL
Program size, estimating B-2
PROGRAMS table
file-label and catalog
inconsistencies 8-4
program invalidation 8-1
SIMILARITYINFO column 8-10
PROGRAMS table, SQL compilation 6-13
Protection view
similarity check rules 8-13
UPDATE statement 4-10
PURGEDATA command and lost open
error 4-3
Q
Question mark (?), unnamed
parameter 10-11
R
READ procedure 1-4
READUPDATE procedure 10-36
RECEIVE file
See $RECEIVE file
RECOMPILE option, SQL compiler 6-17,
8-6
RECOMPILEALL option, SQL
compiler 6-17, 8-6
RECOMPILEONDEMAND option, SQL
compiler 6-17
Record descriptions, tables and views 2-19
Records, SQLSA statistics 9-14