SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-32
T
SUBSTRING function (continued)
operand requirements 9-149
syntax diagram of 9-149
SUM function
DISTINCT clause within 9-151
examples of 9-152
syntax diagram of 9-151
Super ID, privileges for executing
utilities 5-2
SYSKEY
description of 6-60
INVOKE statement 3-66
system-clustered tables 5-81
SYSKEY column, from INVOKE
directive 3-66
SYSKEY, column 2-217
System-clustered tables 5-81
SYSTEM_DEFAULTS metadata
table 10-31
SYSTEM_DEFAULTS table
constraint droppable option 10-42
data types 10-42, 10-43
examples of 10-74
histograms 10-43
isolation level 10-47
locking 10-48
national character set 10-50
nonaudited tables 10-50
object naming 10-51
partition management 10-54
query optimization and
performance 10-57
query plan caching 10-64
referential action 10-66
row maintenance 10-66
scratch disk management 10-67
sequence functions 10-68
statement atomicity 10-69
statement recompilation 10-69
stored procedures in Java 10-71
SYSTEM_DEFAULTS table (continued)
stream access 10-71
table management 10-72
SYSTEM_SQLJ_SCHEMA schema 10-7
T
Table reference
description of 2-203
SELECT statement use of 2-201,
2-202
TABLE statement
examples of 2-247
relationship to SELECT 2-247
syntax diagram of 2-247
Table subquery 6-91
Table value constructor
description of 2-207
simple table, form of 2-207
TABLELOCK default 10-48
Tables, description of 6-108
Tables, limits C-2
TAN function
examples of 9-153
syntax diagram of 9-153
TANH function
examples of 9-153
syntax diagram of 9-153
TBL_CONSTRAINTS metadata
table 10-24
TBL_PRIVILEGES metadata table 10-24
TEMPORARY_TABLE_HASH_PARTITION
S default 10-74
TEXT metadata table 10-25
THIS function
examples of 9-154
syntax diagram of 9-154
TIMEOUT attribute 10-48
TIMEOUT default 10-48
Timeout values
dynamic 2-237