SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-32
T
Super ID, privileges for executing
utilities 5-2
SYSKEY
description of 6-59
INVOKE statement 3-65
system-clustered tables 5-57
SYSKEY column, from INVOKE
directive 3-65
SYSKEY, column 2-194
System-clustered tables 5-57
SYSTEM_DEFAULTS metadata
table 10-30
SYSTEM_DEFAULTS table
constraint droppable option 10-40
data types 10-41
examples of 10-69
histograms 10-41
isolation level 10-45
locking 10-46
national character set 10-47
nonaudited tables 10-48
object naming 10-48
partition management 10-51
query optimization and
performance 10-54
query plan caching 10-59
referential action 10-61
row maintenance 10-61
scratch disk management 10-62
sequence functions 10-63
statement atomicity 10-64
statement recompilation 10-64
stored procedures in Java 10-66
stream access 10-66
table management 10-67
SYSTEM_SQLJ_SCHEMA schema 10-7
T
Table reference
description of 2-180
Table reference (continued)
SELECT statement use of 2-178,
2-179
TABLE statement
examples of 2-223
relationship to SELECT 2-223
syntax diagram of 2-223
Table subquery 6-90
Table value constructor
description of 2-184
simple table, form of 2-184
TABLELOCK default 10-46
Tables, description of 6-107
Tables, limits C-2
TAN function
examples of 9-149
syntax diagram of 9-149
TANH function
examples of 9-149
syntax diagram of 9-149
TBL_CONSTRAINTS metadata
table 10-24
TBL_PRIVILEGES metadata table 10-24
TEMPORARY_TABLE_HASH_PARTITION
S default 10-69
TEXT metadata table 10-25
THIS function
examples of 9-150
syntax diagram of 9-150
TIMEOUT attribute 10-46
TIMEOUT default 10-46
Timeout values
dynamic 2-214
static
lock timeout 2-47, 10-46
stream timeout 2-33, 10-67
Transaction access modes 1-21
Transaction control, statements for 2-3
Transaction isolation levels
READ COMMITTED 1-22
READ UNCOMMITTED 1-21