SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-33
T
partition management 10-63
query optimization and
performance 10-66
query plan caching 10-73
referential action 10-75
row maintenance 10-75
scratch disk management 10-76
sequence functions 10-77
statement atomicity 10-78
statement recompilation 10-78
stored procedures in Java 10-80
stream access 10-80
table management 10-81
SYSTEM_SQLJ_SCHEMA schema 10-6
T
Table reference
description of 2-336
SELECT statement use of 2-334,
2-335
TABLE statement
examples of 2-382
relationship to SELECT 2-382
syntax diagram of 2-382
Table subquery 6-94
Table value constructor
description of 2-340
simple table, form of 2-340
TABLELOCK default 10-57
Tables, description of 6-114
Tables, limits C-2
Table-Valued Stored Functions
FEATURE_VERSION_INFO 8-76
RELATEDNESS 8-144
VERSION_INFO 8-204
TAN function
examples of 8-178
syntax diagram of 8-178
TANH function
examples of 8-178
syntax diagram of 8-178
TBL 10-29
TBL_CONSTRAINTS metadata
table 10-29
TBL_PRIVILEGES metadata table 10-30
TEMPORARY_TABLE_HASH_PARTITION
S default 10-83
TEXT metadata table 10-32
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-326
THIS function
examples of 8-179
syntax diagram of 8-179
TIMEOUT attribute 10-57
TIMEOUT default 10-57
Timeout values
dynamic 2-372
static
lock timeout 2-75, 10-57
stream timeout 2-60, 10-81
TO 8-181, 8-185
TO_CHAR Function 8-181
Transaction access modes 1-23
Transaction control, statements for 2-4
Transaction isolation levels
READ COMMITTED 1-24
READ UNCOMMITTED 1-23
REPEATABLE READ 1-24
SERIALIZABLE 1-24
Transaction management
AUTOCOMMIT, effect of 1-16, 2-269
MODIFY TABLE use of 1-16
rules for DML statements 1-16
Transaction Management Facility
(TMF) 1-13