SQL/MP Programming Manual for C

HP NonStop SQL/MP Programming Manual for C—429847-008
Index-1
Index
A
Accelerator
effect on SQL validity 8-2
running on object file 1-5, 8-2
running on program file 6-13, 6-14
Access authority
DELETE statement 4-23
FETCH statement 4-20
OPEN statement 4-19
SELECT statement 4-21
SQL compilation requirements 6-13
SQL cursor 4-16, 4-18
UPDATE statement 4-22
Access path
EXPLAIN utility 6-16, 6-27
local autonomy 8-6
RECOMPILE option 6-17
SQL compiler function 6-13
unavailable 8-8
valid programs 8-1
ADD command, Binder program 6-12
ADD CONSTRAINT statement, program
invalidation 8-5
add_define OSS utility 6-29
Aggregate functions 9-9
ALLOCATE attribute, similarity check
rules 8-12
ALTER INDEX statement
error 8204 4-3
program invalidation 8-5
ALTER TABLE statement
error 8204 4-3
program invalidation 8-4
similarity check considerations 8-13
ALTER VIEW statement 4-3
Altering SQL file attribute 8-3
Arguments, C compiler, RUN command 7-3
ASSIGN command, TACL 7-2
Asterisk (*)
with pointer as host variable 2-6
with similarity check 8-13
Attributes, SQL file 8-3
AUDIT attribute
altering and automatic
recompilation 8-3
similarity check rules 8-12
AUDITCOMPRESS attribute, similarity
check rules 8-12
Authority requirements for program
execution 7-1
Automatic SQL recompilation
causes 8-6
collation 8-3
functions 8-6
performance considerations B-4
B
Backslash (\), OSS shell escape
character 6-29
Base table
See Table, SQL
BEGIN DECLARE SECTION directive 1-2,
2-1
BEGIN WORK statement 10-27
BIND command 6-12
Binder program
ADD command 6-12
BIND command 6-12
binding object files 6-11
BUILD command 6-12
C programs 6-11
CHANGE command 7-5
description 1-5
effect on SQL validity 8-2
SELECT command 6-12
SET EXTENDSTACK command B-5