Neoview SQL Reference Manual (R2.4 SP2)

examples of, 244
syntax diagram of, 243
Subquery
correlated, 278, 294
description of, 294
inner query, 294
outer query, 294
outer reference, 294
row
BETWEEN predicate, 273
comparison predicate, 275
IN predicate, 279
NULL predicate, 283
quantified comparison predicate, 285
scalar
BETWEEN predicate , 273
comparison predicate , 275
DELETE statement, 107, 198
IN predicate , 279
NULL predicate, 283
quantified comparison predicate, 285
UPDATE statement, 198
table, 279
SUBSTR function
examples of, 460
operand requirements, 459
syntax diagram of, 459
SUBSTRING function
examples of, 460
operand requirements, 459
syntax diagram of, 459
Suitable keys
Neoview SQL guidelines for selecting, 80
SUM function
DISTINCT clause within, 461
examples of, 461
syntax diagram of, 461
SUM window function
examples of, 493
syntax diagram of, 493
Synonyms
considerations, 43, 115
description of, 296
T
Table
creating, 72
description of, 297
dropping, 116
limits, 511
names, reserved, 86
renaming, 47
size, 74
subquery, 279
Table reference
description of, 166
SELECT statement use of, 166
TABLE statement
considerations for, 196
examples, 196
syntax diagram for, 196
Table value constructor
description of, 169
simple table, form of, 169
TAN function
examples of, 462
syntax diagram of, 462
TANH function
examples of, 463
syntax diagram of, 463
THIS function
examples of, 464
syntax diagram of, 464
Timeout values
dynamic, 185
TIMESTAMPADD function
description, 465
examples, 465
TIMESTAMPDIFF function
description, 466
examples, 466
Transaction control statements
BEGIN WORK, 55
COMMIT WORK, 59
ROLLBACK WORK, 162
SET TRANSACTION statement, 187
Transaction isolation levels
READ COMMITTED, 32
READ UNCOMMITTED, 32
REPEATABLE READ, 33
SERIALIZABLE, 33
Transaction management, 29
AUTOCOMMIT, effect of, 29
BEGIN WORK, 55
COMMIT WORK, 59
ROLLBACK WORK, 162
rules for DML statements, 29
SET TRANSACTION , 187
Transaction rollback mode, 33
TRANSLATE function, syntax diagram of, 467
TRANSPOSE clause
cardinality of result, 319
degree of result, 318
examples of, 319
SELECT statement use of, 317
syntax diagram of, 317
Triggers
ALTER TRIGGER statement, 53
CREATE TRIGGER statement, 95
description, 298
DROP TRIGGER statement, 117
TRIM function
examples of, 468
syntax diagram of, 468
U
UCASE function
examples of, 469
536 Index