SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-31
T
SYSTEM_DEFAULTS table (continued)
nonaudited tables 10-47
object naming 10-47
partition management 10-50
query optimization and
performance 10-53
query plan caching 10-58
referential action 10-59
row maintenance 10-59
scratch disk management 10-60
sequence functions 10-61
statement atomicity 10-62
statement recompilation 10-62
stored procedures in Java 10-64
stream access 10-64
table management 10-65
SYSTEM_SQLJ_SCHEMA schema 10-6
T
Table reference
description of 2-184
SELECT statement use of 2-182,
2-183
TABLE statement
examples of 2-228
relationship to SELECT 2-228
syntax diagram of 2-228
Table subquery 6-93
Table value constructor
description of 2-188
simple table, form of 2-188
TABLELOCK default 10-45
Tables, description of 6-110
TAN function
examples of 9-154
syntax diagram of 9-154
TANH function
examples of 9-155
syntax diagram of 9-155
TBL_CONSTRAINTS metadata
table 10-23
TBL_PRIVILEGES metadata table 10-23
TEMPORARY_TABLE_HASH_PARTITION
S default 10-67
TEXT metadata table 10-24
THIS function
examples of 9-156
syntax diagram of 9-156
TIMEOUT attribute 10-45
TIMEOUT default 10-45
Timeout values
dynamic 2-218
static
lock timeout 2-49, 10-45
stream timeout 2-35, 10-65
Transaction access modes 1-19
Transaction control, statements for 2-3
Transaction isolation levels
audited tables and
SERIALIZABLE 1-21
READ COMMITTED 1-20
READ UNCOMMITTED 1-20
REPEATABLE READ 1-21
SERIALIZABLE 1-21
Transaction management
AUTOCOMMIT, effect of 1-13, 2-161
MODIFY TABLE use of 1-13
rules for DML statements 1-13
Transaction Management Facility
(TMF) 1-11
Transaction management statements
BEGIN WORK 2-27
COMMIT WORK 2-32
ROLLBACK WORK 2-176
SET TRANSACTION statement 2-223
Transactions 1-13
TRANSLATE function, syntax diagram
of 9-158
TRANSPOSE clause
cardinality of result 7-28