SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-6
H
Guardian 90 operating system 4-2, 4-7,
4-8
, 4-14
H
HEADING attribute 4-20
HELP TEXT attribute 4-20
Host variable
array as 2-11
associated indicator variable for 2-13
creating with INVOKE 2-20
date-time data types as 2-15
declaration of 1-3, 3-6
declaring 2-2
fields in a structure as 2-8
in expressions 2-2
INDICATOR clause 2-7
initializing in cursor 3-35
INTERVAL data types as 2-15
multiple DECLARE sections for 2-2
naming conventions 2-2
null values in 2-7
pointer as 2-9
scale in 2-12
string parameter as 2-11
structure as 2-8
syntax for using 2-7
TYPE AS clause 2-7
type STRING array as 2-10
using colon (:) with 1-3
using INSERT with 3-19
with DELETE statement 3-13
HP NonStop Transaction Management
Facility (TMF) 1-1
, 7-13
Hyphen, double (--) for SQL comments 3-2
I
INCLUDE SQLCA directive 3-19, 4-2, 6-9,
7-8
INCLUDE SQLDA directive 3-19, 6-14
INCLUDE SQLSA directive 3-19, 6-11, 7-8
Incompatible features
C10 description D-4
C30 enhancements D-1
Index, SQL
changes and program file validity 5-23
version 2 D-2
INDICATOR clause
in SETSCALE function 2-13
with host variable 2-7
Indicator parameter
function 2-25
in names buffer 7-38
syntax for 2-23
Indicator variable
allocating memory for 7-37
using for null value 2-17
with aggregate function 6-7
with host variable 2-7
with INVOKE directive 3-27
IND^PTR field
in SQLDA structure 7-5
IND^PTR, initializing 7-18
Initializing a cursor 3-35
INNER function
reserved word for C30 D-5
Input host variable
with DESCRIBE and DESCRIBE
INPUT 3-16
Input parameter
for dynamic SQL operations 7-4
, 7-10
Insert operation
timestamp value 3-21
with a null value 3-20
INSERT statement, SQL 3-19
Insertion program, static SQL B-1
Installing migrated programs D-8
INT (32) TAL data type
with SETSCALE SQL function 3-21