Neoview SQL Reference Manual (R2.3)

examples of, 419
syntax diagram of, 419
Standards
ANSI SQL, 465
character set support, 470
ISO, 465
Statement atomicity
automatic, 32
description of, 32
Statements, SQL
ANSI compliant, 37
Neoview SQL extensions, 38
Statistics
clearing, 185
UPDATE STATISTICS statement
considerations, 188
examples of, 189
STDDEV function
DISTINCT clause within, 420
examples of, 421
statistical definition of, 420
syntax diagram of, 420
STDDEV window function
syntax diagram of, 453
Stored procedure statements, 43
CALL, 53
GRANT EXECUTE, 120
REVOKE EXECUTE, 139
Stored text
reserved words, 459
Stream timeout
dynamic, SET TABLE TIMEOUT statement setting,
168
String literals, 233
String value expression
examples of, 218
syntax diagram of, 218
STTDEV window function
examples of, 454
Subquery
correlated, 248, 261
description of, 260
inner query, 260
outer query, 260
outer reference, 261
row
BETWEEN predicate, 243
comparison predicate, 245
IN predicate, 249
NULL predicate, 251
quantified comparison predicate, 252
scalar
BETWEEN predicate , 243
comparison predicate , 245
DELETE statement, 92, 180
IN predicate , 249
NULL predicate, 251
quantified comparison predicate, 252
UPDATE statement, 180
table, 249
SUBSTR function
examples of, 423
operand requirements, 422
syntax diagram of, 422
SUBSTRING function
examples of, 422
operand requirements, 422
syntax diagram of, 422
SUM function
DISTINCT clause within, 424
examples of, 424
syntax diagram of, 424
SUM window function
examples of, 454
syntax diagram of, 454
Synonyms
considerations, 46, 68, 99
T
table names, reserved, 75
Table reference
description of, 148
SELECT statement use of, 148
Table subquery, 249
Table value constructor
description of, 151
simple table, form of, 151
table,
renaming, 48
Tables, description of, 262
Tables, limits, 463
TAN function
examples of, 425
syntax diagram of, 425
TANH function
examples of, 426
syntax diagram of, 426
THIS function
examples of, 427
syntax diagram of, 427
Timeout values
dynamic, 168
Transaction control, statements for, 42
Transaction isolation levels
READ COMMITTED, 36
READ UNCOMMITTED, 36
REPEATABLE READ, 37
SERIALIZABLE, 37
Transaction management
AUTOCOMMIT, effect of, 33, 130
rules for DML statements, 33
Transaction management statements
BEGIN WORK, 52
ROLLBACK WORK, 143
SET TRANSACTION statement, 170
transaction rollback mode, 37
Transactions, 33
TRANSLATE function, syntax diagram of, 428
482 Index