Neoview SQL Reference Manual (R2.4)

Synonyms
considerations, 44, 113
description of, 289
T
Table
description of, 290
limits, 505
names, reserved, 83
size, 73
subquery, 273
Table reference
description of, 166
SELECT statement use of, 166
Table value constructor
description of, 169
simple table, form of, 169
Tables
creating, 70
renaming, 48
TAN function
examples of, 457
syntax diagram of, 457
TANH function
examples of, 458
syntax diagram of, 458
THIS function
examples of, 459
syntax diagram of, 459
Timeout values
dynamic, 185
TIMESTAMPADD function
description, 460
examples, 460
TIMESTAMPDIFF function
description, 461
examples, 461
Transaction control statements
BEGIN WORK, 54
COMMIT WORK, 58
MERGE INTO, 149
ROLLBACK WORK, 161
SET TRANSACTION , 187
Transaction isolation levels
READ COMMITTED, 34
READ UNCOMMITTED, 34
REPEATABLE READ, 35
SERIALIZABLE, 35
Transaction management, 31
AUTOCOMMIT, effect of, 31, 147
BEGIN WORK, 54
COMMIT WORK, 58
ROLLBACK WORK, 161
rules for DML statements, 31
SET TRANSACTION , 187
Transaction rollback mode, 35
TRANSLATE function, syntax diagram of, 462
TRANSPOSE clause
cardinality of result, 311
degree of result, 310
examples of, 311
SELECT statement use of, 309
syntax diagram of, 309
Triggers
ALTER TRIGGER statement, 52
considerations, 94
CREATE TRIGGER statement, 93
description, 291
DROP TRIGGER statement, 115
TRIM function
examples of, 463
syntax diagram of, 463
U
UCASE function
examples of, 471
syntax diagram of, 464
Union operation
associative, UNION ALL, 176
columns, characteristics of, 175
ORDER BY clause restriction, 176
SELECT statement use of, 171
Updatable view, requirements for, 101
UPDATE Statement
examples of, 200
UPDATE statement
authorization requirements, 198
conflicting updates, 199
description of, 196
isolation levels, 199
performance, 198
SET clause, 197
SET ON ROLLBACK clause, 197
SKIP CONFLICT access, 198
syntax diagram of, 196
WHERE clause, 198
UPDATE STATISTICS statement
column groups, 203
column lists, 203
considerations, 205
description of, 202
examples of, 206
histogram tables, 203
syntax diagram of, 202
table row count, 205
UPPER function
examples of, 472
syntax diagram of, 472
Upsert
MERGE INTO, 149
using single row, 149
UPSHIFT function
syntax diagram of, 473
USER function
example of, 474
syntax diagram of, 474
Utilities
MAINTAIN command, 210
528 Index