HP NonStop SQL/MP - Page 329

Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-17
U
Table, SQL (continued)
maximizing local autonomy for
partitions C-1
open time and automatic SQL
recompilation 8-7
SELECT statement 4-4
similarity check rules 8-12
UPDATE statement 4-10
Table, SQL, updating statistics 6-21
Tandem Advanced Command Language
(TACL)
DEFINEs
catalog name 6-6, 6-15
CLASS CATALOG 6-6, 6-15
description 7-2
maximizing local autonomy C-2
OSS environment 6-29
RECOMPILE clause 6-17
SQL compilation 6-15, 6-24
SQL compiler 6-6
SQL program file 7-2
HIGHPIN run option 7-5
PARAM command 7-2
RUN command
C pragma 3-2
SQL program file 1-5, 7-3
RUN command, C compiler 6-9
run options for SQL program file 7-3
RUND command 7-3
Tandem NonStop Series/RISC (TNS/R)
system 6-11
, 6-31
Terminator, SQL statement 3-1
Timestamp
check at table open time 8-7
collation check 8-15
INSERT statement 4-10
program validation time 8-1
run-time check 8-7
TMF
See Transaction Management Facility
(TMF)
TNS/R system 1-5
Transaction Application Language (TAL),
host language 1-1
Transaction control statements 1-3
Transaction Management Facility (TMF)
catalog inconsistencies 8-4
data consistency 1-1
example 9-11
FETCH statement 4-20
OPEN statement 4-15
UPDATE statement 4-10
with dynamic SQL 10-27
TRANSIDS tables 6-13
TYPE AS clause
example 2-14
with date-time data 2-14
with host variable 2-7
with INVOKE directive 2-14
U
Uncompiled SQL statements, FORCE
option 6-23
Underlying SQL tables and similarity
check 8-10
Unqualified column names with similarity
check 8-14
UPDATE set operations, automatic
recompilation 8-3
UPDATE statement
description 4-10
multiple rows 4-12
null values 4-12
scale for numeric data 2-12, 2-13
set of rows 4-12
single row 4-11
using parameter 10-12