SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-33
T
character set 10-61
constraint droppable option 10-51
data types 10-52, 10-53
examples of 10-85
histograms 10-53
isolation level 10-57
locking 10-58
nonaudited tables 10-61
object naming 10-62
partition management 10-64
query optimization and
performance 10-68
query plan caching 10-75
referential action 10-77
row maintenance 10-77
scratch disk management 10-78
sequence functions 10-79
statement atomicity 10-80
statement recompilation 10-80
stored procedures in Java 10-82
stream access 10-82
table management 10-83
SYSTEM_SQLJ_SCHEMA schema 10-6
T
Table reference
description of 2-261
SELECT statement use of 2-259,
2-260
TABLE statement
examples of 2-307
relationship to SELECT 2-307
syntax diagram of 2-307
Table subquery 6-94
Table value constructor
description of 2-265
simple table, form of 2-265
TABLELOCK default 10-58
Tables, description of 6-111
Tables, limits C-2
Table-Valued Stored Functions
FEATURE_VERSION_INFO 9-76
RELATEDNESS 9-144
VERSION_INFO 9-204
TAN function
examples of 9-178
syntax diagram of 9-178
TANH function
examples of 9-178
syntax diagram of 9-178
TBL 10-31
TBL_CONSTRAINTS metadata
table 10-31
TBL_PRIVILEGES metadata table 10-32
TEMPORARY_TABLE_HASH_PARTITION
S default 10-85
TEXT metadata table 10-33
The following is the syntax to remove SA
designation from a Guardian user
REVOKE SECURITY_ADMIN from
"USER" where
USER is either USERNAME or
USERID USERNAME is a Guardian
user name USERID is numeric
Guardian USERID An SA can issue
a REVOKE statement to 2-251
THIS function
examples of 9-179
syntax diagram of 9-179
TIMEOUT attribute 10-58
TIMEOUT default 10-58
Timeout values
dynamic 2-297
static
lock timeout 2-67, 10-58
stream timeout 2-52, 10-83
TO 9-181, 9-185
TO_CHAR Function 9-181
Transaction access modes 1-23
Transaction control, statements for 2-4
Transaction isolation levels