SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-33
T
SYSTEM_DEFAULTS table (continued)
data types 10-48, 10-49
examples of 10-79
histograms 10-49
isolation level 10-53
locking 10-54
nonaudited tables 10-57
object naming 10-57
partition management 10-60
query optimization and
performance 10-63
query plan caching 10-70
referential action 10-71
row maintenance 10-71
scratch disk management 10-72
sequence functions 10-73
statement atomicity 10-74
statement recompilation 10-74
stored procedures in Java 10-76
stream access 10-76
table management 10-77
SYSTEM_SQLJ_SCHEMA schema 10-7
T
Table reference
description of 2-204
SELECT statement use of 2-202,
2-203
TABLE statement
examples of 2-250
relationship to SELECT 2-250
syntax diagram of 2-250
Table subquery 6-94
Table value constructor
description of 2-208
simple table, form of 2-208
TABLELOCK default 10-54
Tables, description of 6-111
Tables, limits C-2
Table-Valued Stored Functions
FEATURE_VERSION_INFO 9-64
RELATEDNESS 9-126
VERSION_INFO 9-177
TAN function
examples of 9-160
syntax diagram of 9-160
TANH function
examples of 9-160
syntax diagram of 9-160
TBL_CONSTRAINTS metadata
table 10-26
TBL_PRIVILEGES metadata table 10-27
TEMPORARY_TABLE_HASH_PARTITION
S default 10-79
TEXT metadata table 10-28
THIS function
examples of 9-161
syntax diagram of 9-161
TIMEOUT attribute 10-54
TIMEOUT default 10-54
Timeout values
dynamic 2-240
static
lock timeout 2-49, 10-54
stream timeout 2-34, 10-77
Transaction access modes 1-21
Transaction control, statements for 2-3
Transaction isolation levels
READ COMMITTED 1-22
READ UNCOMMITTED 1-21
REPEATABLE READ 1-22
SERIALIZABLE 1-22
Transaction management
AUTOCOMMIT, effect of 1-15, 2-181
MODIFY TABLE use of 1-15
rules for DML statements 1-15
Transaction Management Facility
(TMF) 1-12
Transaction management statements
BEGIN WORK 2-25