Neoview SQL Reference Manual (R2.2)

correlated, 238, 251
description of, 250
inner query, 250
outer query, 250
outer reference, 251
row
BETWEEN predicate, 233
comparison predicate, 235
IN predicate, 239
NULL predicate, 241
quantified comparison predicate, 242
scalar
BETWEEN predicate , 233
comparison predicate , 235
DELETE statement, 91, 170
IN predicate , 239
NULL predicate, 241
quantified comparison predicate, 242
UPDATE statement, 170
table, 239
SUBSTR function
examples of, 412
operand requirements, 411
syntax diagram of, 411
SUBSTRING function
examples of, 411
operand requirements, 411
syntax diagram of, 411
SUM function
DISTINCT clause within, 413
examples of, 413
syntax diagram of, 413
Super ID, privileges for executing utilities, 181
Synonyms
considerations, 46, 68, 97
T
table names, reserved, 74
Table reference
description of, 145
SELECT statement use of, 145
Table subquery, 239
Table value constructor
description of, 148
simple table, form of, 148
table,
renaming, 48
Tables, description of, 252
Tables, limits, 441
TAN function
examples of, 414
syntax diagram of, 414
TANH function
examples of, 415
syntax diagram of, 415
THIS function
examples of, 416
syntax diagram of, 416
Timeout values
dynamic, 164
Transaction control, statements for, 42
Transaction isolation levels
READ COMMITTED, 36
READ UNCOMMITTED, 36
REPEATABLE READ, 36
SERIALIZABLE, 36
Transaction management
AUTOCOMMIT, effect of, 33, 127
rules for DML statements, 33
Transaction management statements
BEGIN WORK, 52
ROLLBACK WORK, 140
SET TRANSACTION statement, 166
transaction rollback mode, 37
Transactions, 33
TRANSLATE function, syntax diagram of, 417
TRANSPOSE clause
cardinality of result, 273
degree of result, 272
examples of, 273
SELECT statement use of, 271
syntax diagram of, 271
Trigger statements, 43
Triggers
ALTER TRIGGER statement, 50
considerations, 82
CREATE TRIGGER statement, 81
description, 253
DROP TRIGGER statement, 99
TRIM function
examples of, 418
syntax diagram of, 418
U
UCASE function
examples of, 425
syntax diagram of, 419
Union operation
associative, UNION ALL, 155
columns, characteristics of, 154
ORDER BY clause restriction, 155
SELECT statement use of, 150
Updatable view, requirements for, 89
UPDATE statement
authorization requirements, 171
conflicting updates, 171
SET clause, 170
SET ON ROLLBACK clause, 170
SET ROLLBACK clause, 170
SKIP CONFLICT access, 171
syntax diagram of, 169
WHERE clause, 171
UPDATE STATISTICS statement
column groups, 176
column lists, 176
examples of, 178
histogram tables, 176
syntax diagram of, 175
460 Index