SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-7
J
INTERVAL data types
conversion of 2-4
inserting 2-16, 3-26
literals for 6-19
selecting 3-25
with INVOKE directive 3-24
INTO clause
with SELECT command 3-32
INVALIDATE option, CREATE INDEX
statement 5-23
INVOKE directive, SQL 2-8, 2-17, 2-20,
3-22
, A-1
Item codes
for SQLCAGETINFOLIST (table) 4-10
SQLCAGETINFOLIST parameter 4-8
J
JOIN function
for C10 program migration D-4
reserved word for C30 D-5
JULIANTIMESTAMP system
procedure 3-22
L
LEFT function
for C10 program migration D-4
reserved word for C30 D-5
Library procedures, system 1-3
List file
SQL compiler 5-6
TAL compiler 5-3
Listing, SQL compiler 5-15
Literal declarations
for data types 7-21
for DATA^TYPE field 6-18
for date-time values 6-19
for INTERVAL data types 6-19
for PRECISION field 6-18
SQLDA^EYE^CATCHER 6-18
Load time, SQL 5-25
Local autonomy
maximizing for distributed
database 5-28
program execution 5-24
program file validity 5-23
skipping unavailable partitions to
maximize 5-28
using current statistics 5-29
using TACL DEFINEs 5-29
Local partition
using to maximize local autonomy 5-28
Loops, infinite
avoiding with WHENEVER 6-5
M
MAPPED option, SQLMEM directive 3-39
Measure program 3-37
Memory management
dynamic allocation 7-14
estimating use 5-32
using SQLMEM directive 3-37
Migration, C10 program to C30 D-4
Modifying data
DELETE statement 3-13
UPDATE statement 3-43
MOVEX system procedure 3-39
Moving SQL files, effect on SQL
validity 5-22
MULTILAN
with dynamic SQL programs 7-2
Multiple SQL releases
running program on D-13
Multi-row
delete 3-14
retrieval 3-33
update 3-44
N
Names buffer
and indicator parameters 7-38