SQL Programming Manual for Pascal

HP NonStop SQL Programming Manual for Pascal—528614-001
Index-1
Index
A
Accelerator 5-2, 5-5
Access path
local autonomy 5-28
RECOMPILE option 5-9
results when unavailable 5-25
SQL compiler function 5-11
valid programs 5-21
Access privileges
for SQL compiler 5-10
Advantages of embedded SQL 1-1
Aggregate functions
and WHENEVER 6-7
version issues D-5
Altering SQL file attribute, effect of 5-23
ANYWHERE clause
with INSERT statement 3-18
APPEND clause
with INSERT statement 3-19
Authority
for program execution 5-31
Automatic SQL recompilation 5-24
B
BEGIN DECLARE SECTION directive 2-2,
3-3, 3-5
BEGIN WORK statement 7-12
Binder program 5-1, 5-2, 5-4
Binding object files
and SQL validation 5-22
using mixed versions D-10
BINSERV
PARAM command 5-13
process for SQL compilation 5-14
BROWSE ACCESS clause
with SELECT statement 3-30
C
C10 applications, migrating D-7
C30 features, migrating applications D-4
CALL format of WHENEVER 6-5
Catalog access
program execution 5-10
CATALOG name, SQL compiler 5-7
Catalogs
handling mixed versions D-12
Version 1 D-1
Version 2 D-1
CLOSE statement 3-7, 3-13, 3-34
Column, definition depending on
version D-4
Comments, in SQL statements 3-2
Compilation
See Automatic recompilation
Compiler directives
for Pascal compiler 5-4
Compiling
automatic SQL recompilation 5-24
dynamic SQL statements 5-15
explicit SQL 5-5
Pascal source statements 5-1
Constraints E-1
creating E-1
for enforcing data integrity E-1
Constraint, changes and program file
validity 5-23
CONTROL directives 3-8
CONTROL EXECUTOR directive 3-8
CONTROL QUERY directive 3-8
CONTROL TABLE directive 3-8, 5-29
Copying SQL files, effect of 5-22
CREATE TABLE statement, version
issue D-4
CURRENTDEFINES option, SQL
compiler 5-8