SQL Programming Manual for TAL

HP NonStop SQL Programming Manual for TAL—527887-001
Index-1
Index
A
Accelerator
effect on SQL validity 5-22
running on object file 1-7, 5-5, D-9
using SQL object file for 5-12
Access path
EXPLAIN utility 5-18
local autonomy 5-28
RECOMPILE option 5-9
SQL compiler function 5-5
unavailable 5-26
using EXPLAIN with 5-17
valid programs 5-22
Access privileges
for SQL compiler 5-10
ADD Command, Binder 5-5
ADD DEFINE command, TACL 5-19
Aggregate functions
for C10 program migration D-5
using in a program 6-7
ALLOCATESEGMENT system
procedure 3-41
Allocating memory
for indicator variables 7-37
Altering SQL file attribute, effect of 5-23
ANYWHERE clause
with INSERT statement 3-20
APPEND clause
with INSERT statement 3-20
Array as host variable 2-11
ASSIGN command, TACL
for SQL program file 5-30
Attributes, SQL file
effect of altering 5-23
Authority
for program file execution 5-30
Automatic SQL recompilation
functions of 5-24
Automatic SQL recompilation (continued)
performance considerations 5-24
predicting 5-24
AVG function
for C10 program migration D-5
B
BACKUP/RESTORE program
version issues D-9
BEGIN DECLARE SECTION Directive,
SQL 3-6
BEGIN DECLARE SECTION directive,
SQL 1-3
, 2-2
BEGIN WORK statement, SQL 7-13
Binder program 1-7, 5-12
ADD command 5-5
binding mixed-version object files D-11
binding object files 5-4
BUILD command 5-5
effect on SQL validity 5-22
SELECT command 5-5
STRIP command 5-4
using with TALLIB 5-4
BINSERV
option in PARAM command 5-13
process 7-8
BROWSE ACCESS clause
with SELECT statement 3-32
BUILD command, Binder 5-5
C
C programming language 1-1
C10 program, migrating to C30 D-4
C30 features, migrating program for D-3
CALL format of WHENEVER 6-7
CATALOG clause
for SQL compiler 5-7
CATALOG TACL DEFINE 5-7