SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-14
T
T
Table, SQL
changes and program file validity 5-23
maximizing local autonomy for
partitions 5-28
, 5-30
open time and automatic SQL
recompilation 5-25
using SELECT statement 3-32
version 2 D-2
TACL
ASSIGN command for SQL program
file 5-30
DEFINEs
ADD DEFINE command 5-19
CLASS CATALOG 5-7
DEFMODE option 5-19, 5-32
for automatic SQL
recompilation 5-25
for SQL program execution 5-32
for SQL program file 5-30
propagating 5-32
SET DEFINE command 5-19
using to maximize local
autonomy 5-29
using with SQL compiler 5-32
using with TAL compiler 5-31
in sample program B-1, C-1
PARAM command for SQL program
file 5-30
RUN command
for SQL object file 5-30
for TAL compiler 5-3
parameters for SQL object file 5-30
run option
for SQL object file 5-31
for SQLCOMP command 5-7
for TAL compiler 5-3
RUND command
for SQL object file 5-30
Timestamp
check at table open time 5-25
program validation time 5-22
run-time check 5-26
with INSERT statement 3-21
TNS/R 1-7
Transaction Application Language (TAL)
compiler
running 3-2
using TACL DEFINEs with 5-31
WHENEVER pseudocode 6-4
compiler directives
DATAPAGES 7-8
in RUN command 5-4
SEARCH 3-3, 5-4
SOURCE 3-3
SQL 3-1, 3-2, 3-40, 5-4
SQLMEM 3-1, 3-42
SYMBOLPAGES 3-1, 3-3, 3-42
compiler syntax 5-6
ELSE keyword in SQL statements 1-2,
3-1
END keyword in SQL statements 1-2,
3-1
program development with 1-2
TALDECS 6-18, 7-21
TALLIB 1-7, 7-8
TALLIB file 5-5
UNTIL keyword in SQL statements 1-2,
3-1
Transaction Manangement Facility (TMF)
See HP NonStop Transaction
Manangement Facility
TRANSIDS tables 5-10
Two-code thread design D-13
TYPE AS clause
examples of 2-16
with a parameter 2-24
with date-time data 2-16
with host variable 2-5, 2-7