SQL/MP Programming Manual for COBOL85

Index
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
Index-7
I
Host variables (continued)
associating with a character set 2-24
COBOL statements 2-25
creating with INVOKE directive 2-13
declaring 1-2, 2-1
description 1-1, 2-1
initializing 4-16
naming conventions 2-2
syntax for specifying 2-6
use of colon when specifying 1-2, 2-6
HOSV (host object SQL version) 6-44
I
IN EXCLUSIVE MODE, SELECT
statement 4-6, 4-13
IN SHARE MODE, SELECT statement 4-6
INCLUDE SQLCA directive
description 3-3
example 9-4
syntax 9-11
INCLUDE SQLCODEX directive 3-4
INCLUDE SQLDA directive
considerations 10-16
description 3-4
syntax 10-15
INCLUDE SQLSA directive
description 3-4
syntax 9-21
INCLUDE STRUCTURES directive
embedded 3-3
syntax 9-1
versions D-1
Indicator parameters
dynamic SQL 10-8
names buffer 10-24
Indicator variable
description 2-1
null value 2-10
specifying 2-6
with aggregate function 9-9
Indicator variable (continued)
with INVOKE directive 2-13, 2-21
IND-PTR, SQLDA structure field 10-13
Infinite loops, avoiding with
WHENEVER 9-8
INFO DEFINE format, EXPLAIN
report 6-39
Inoperable plan, description 8-9
Input parameters, handling null
values 10-28
Input variable, description 2-1
INPUT-NAMES-LEN, SQLSA structure
field 9-23
INPUT-NUM, SQLSA structure field 9-23
INSERT statement
description 4-1, 4-6
example 1-6
indicator variables 2-10
null value 4-7
single-row 4-7
SQLCODE values 4-6
timestamp value 4-8
Inspect program, RUND command 7-2
INTERVAL data type
date-time 2-18
description 2-9
specifying 2-6
with INVOKE directive 2-17
Invalid SQL program 8-1, 8-6
Invalidation
causes 8-2
changes to referenced SQL objects 8-2
file-label and catalog
inconsistencies 8-4
preventing with CHECK INOPERABLE
PLANS option 8-4
INVOKE directive
advantages 2-13
creating host variables 2-13
description 3-4
NULL STRUCTURE clause 2-21