SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-33
T
examples of 10-82
histograms 10-52
isolation level 10-56
locking 10-57
nonaudited tables 10-60
object naming 10-60
partition management 10-63
query optimization and
performance 10-66
query plan caching 10-73
referential action 10-74
row maintenance 10-74
scratch disk management 10-75
sequence functions 10-76
statement atomicity 10-77
statement recompilation 10-77
stored procedures in Java 10-79
stream access 10-79
table management 10-80
SYSTEM_SQLJ_SCHEMA schema 10-7
T
Table reference
description of 2-248
SELECT statement use of 2-246,
2-247
TABLE statement
examples of 2-294
relationship to SELECT 2-294
syntax diagram of 2-294
Table subquery 6-94
Table value constructor
description of 2-252
simple table, form of 2-252
TABLELOCK default 10-57
Tables, description of 6-111
Tables, limits C-2
Table-Valued Stored Functions
FEATURE_VERSION_INFO 9-71
RELATEDNESS 9-139
VERSION_INFO 9-199
TAN function
examples of 9-173
syntax diagram of 9-173
TANH function
examples of 9-173
syntax diagram of 9-173
TBL 10-29
TBL_CONSTRAINTS metadata
table 10-29
TBL_PRIVILEGES metadata table 10-30
TEMPORARY_TABLE_HASH_PARTITION
S default 10-82
TEXT metadata table 10-31
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-238
THIS function
examples of 9-174
syntax diagram of 9-174
TIMEOUT attribute 10-57
TIMEOUT default 10-57
Timeout values
dynamic 2-284
static
lock timeout 2-66, 10-57
stream timeout 2-51, 10-80
TO 9-176, 9-180
TO_CHAR Function 9-176
Transaction access modes 1-22
Transaction control, statements for 2-4
Transaction isolation levels
READ COMMITTED 1-23
READ UNCOMMITTED 1-22
REPEATABLE READ 1-23
SERIALIZABLE 1-23