SQL Programming Manual for Pascal

Index
HP NonStop SQL Programming Manual for Pascal—528614-001
Index-7
Q
Parameters
example of 2-13
indicator 2-13
syntax for 2-12
Pascal compiler 3-2
syntax 5-3
WHENEVER pseudocode 6-4
Pascal run-time library 5-2
Pathway
dynamic SQL server 7-2
error checking with requester 3-34
Performance 5-22
PEXTDECS file 1-3, 4-1, 6-18, 7-2, 7-24
Physical file attributes
See File attributes
PRECISION field, in SQLDA 7-5
PREFIX clause
with INVOKE 3-26
PREPARE statement 2-13, 3-29, 4-23,
5-15, 7-9
Program dependencies
send automatic SQL
recompilation 5-24
Program execution
for SQL programs 5-31
using DEFINEs 5-31
Program size, estimating 5-32
Programmatic versioning features D-11
PROGRAMS table 5-10
Propagating DEFINEs 5-32
Q
Query decomposition in EXPLAIN
plan 5-18
Quotation marks (" and ") 3-2
R
Recompilation
See Automatic recompilation
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-1, E-2
managing E-2
Relative table, insert into 3-18
RELEASE1 option, SQL directive 3-35
RELEASE2 option, SQL directive 3-35
Renaming program files, effect of 5-23
Reserved words, version issue D-5
RETURNING LASTSYSKEY option
INSERT statement 7-6
Rows
fetching 3-17
inserting 3-18
Row, single
delete 3-11
Row-at-a-time
delete 3-11
select 3-29
update 3-37
RUN command, TACL 5-3
Run option
for Pascal compiler 5-3
for SQL object file 5-31
Running on multiple releases D-12
Run-time memory allocation 7-8
S
Sample database A-1
Scale, numerics items with 7-30
SELECT statement 2-11, 3-9, 3-34, 7-4
Selecting data, cursor Declaration 3-10
Semicolon (;)
in SQL statements 3-1
SENSITIVE flag, SQL 5-22