HP NonStop SQL/MP - Page 320

Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-8
J
Indicator variable
aggregate function 9-9
definition 2-1
host variable 2-6
INVOKE directive 2-22
PREFIX and SUFFIX clauses 2-23
ind_ptr field, initializing 10-29
INFO DEFINE format, EXPLAIN
report 6-27
info_define OSS utility 6-29
Inoperable execution plan 8-10
Input host variable 2-1
Input parameter, dynamic SQL 10-11,
10-24
Insert operation of timestamp value 4-10
INSERT statement
description 4-8
null values 2-17, 4-9
scale for numeric data 2-12, 2-13
Inspect program, RUND command 7-3
INTERVAL data types
description 2-13
INSERT statement 2-14
INVOKE directive 2-14
INVALIDATE option, CREATE INDEX
statement 8-3
Invalidation caused by DDL operations 8-4
INVOKE directive
creating host variables 2-19
through SQLCI 2-24
Item codes
SQLCAGETINFOLIST 5-11
SQLCAGETINFOLIST parameter 5-10
J
JULIANTIMESTAMP procedure 4-10
K
Key tags, similarity check rules 8-12
L
Library procedures, system 1-4
List file
C compiler 6-9
SQL compiler 6-14
LOAD command and lost open error 4-3
Load time, SQL 8-6
Local autonomy
maximizing for distributed
database C-1
program execution 8-6
program file validity 8-4
TACL DEFINEs C-2
using current statistics C-2
Local partition, to maximize local
autonomy C-1
LOCKLENGTH attribute, similarity check
rules 8-12
Locks, FREE RESOURCES
statement 4-24
Logical DEFINE
See DEFINEs, TACL
longlong_to_dec C routine 2-11
Loops, infinite, WHENEVER directive 9-8
Lost open error (SQL error -8204) 4-2
M
MAXEXTENTS attribute, similarity check
rules 8-12
Maximizing local autonomy
See Local autonomy
Measure program 6-7
MEM option, TACL B-5
Memory management
dynamic allocation 10-18
estimating use B-2
SQLMEM pragma B-2
Memory model 10-18, 10-29
Memory stack overflows B-4