Neoview SQL Reference Manual (R2.5)

Transaction control statements
BEGIN WORK, 55
COMMIT WORK, 59
ROLLBACK WORK, 163
SET TRANSACTION statement, 188
Transaction isolation levels
READ COMMITTED, 32
READ UNCOMMITTED, 32
REPEATABLE READ, 33
SERIALIZABLE, 33
Transaction management, 28
AUTOCOMMIT, effect of, 29
BEGIN WORK, 55
COMMIT WORK, 59
ROLLBACK WORK, 163
rules for DML statements, 29
SET TRANSACTION , 188
Transaction rollback mode, 33
TRANSLATE function, syntax diagram of, 479
TRANSPOSE clause
cardinality of result, 331
degree of result, 330
examples of, 331
SELECT statement use of, 329
syntax diagram of, 329
Triggers
ALTER TRIGGER statement, 53
CREATE TRIGGER statement, 96
description, 311
DROP TRIGGER statement, 119
TRIM function
examples of, 480
syntax diagram of, 480
U
UCASE function
examples of, 481
syntax diagram of, 481
Union operation
associative, UNION ALL, 177
columns, characteristics of, 176
ORDER BY clause restriction, 177
SELECT statement use of, 172
Updatable view, requirements for, 103
UPDATE statement
authorization requirements, 200
conflicting updates, 201
description of, 198
examples of, 202
isolation levels, 201
performance, 200
SET clause, 199
SET ON ROLLBACK clause, 199
SKIP CONFLICT access, 200
syntax diagram of, 198
WHERE clause, 200
UPDATE STATISTICS statement
column groups, 205
column lists, 205
considerations, 207
examples of, 209
histogram tables, 205
persistent sample tables, 207
syntax diagram of, 204
UPPER function
examples of, 482
syntax diagram of, 482
Upsert
using single row, 151
UPSHIFT function
syntax diagram of, 483
USER function
example of, 484
syntax diagram of, 484
Utilities
MAINTAIN command, 212
POPULATE INDEX utility, 220
PURGEDATA utility, 222
REPLICATE command, 224
V
Value expressions, 255
summary of, 343
CASE (Conditional) expression, 354
CAST expression, 357
VALUES statement
considerations for, 210
examples, 210
syntax diagram for, 210
VARCHAR data type, 248, 249
Variable-length character column, 249
VARIANCE function
DISTINCT clause within, 485
examples of, 486
statistical definition of, 485
syntax diagram of, 485
VARIANCE window function
examples of, 507
syntax diagram of, 507
Vertical partition
example, 106
FOREIGN KEY constraint, 106
Views
CREATE VIEW statement, 102
description of, 312
DROP VIEW statement, 120
relationship to tables, 310
updatability requirements, 103
Volatile tables
considerations, 79
examples, 81, 93
nullable constraints, 81
nullable keys, 80
nullable primary key, 81
suitable keys, 80
W
WEEK function
549