Neoview SQL Reference Manual (R2.5)

syntax diagram of, 468
Standards
ANSI SQL, 525
character set support, 529
ISO, 525
Statement atomicity
automatic, 28
description of, 28
Statements, SQL
ANSI compliant, 33
Neoview SQL extensions, 34
Statistics
clearing, 205
UPDATE STATISTICS statement, 207, 209
STDDEV function
DISTINCT clause within, 469
examples of, 470
statistical definition of, 469
syntax diagram of, 469
STDDEV window function
examples of, 504
syntax diagram of, 504
STORE BY clause, 74
Stored procedure statements, 39
CALL, 56
GRANT EXECUTE, 138
REVOKE EXECUTE, 158
Stored text
reserved words, 519
Stream timeout
dynamic, SET TABLE TIMEOUT statement setting,
186
String literals, 274
String value expression
examples of, 256
syntax diagram of, 255
Subquery
correlated, 291, 308
description of, 307
inner query, 307
outer query, 307
outer reference, 308
row
BETWEEN predicate, 286
comparison predicate, 288
IN predicate, 292
NULL predicate, 296
quantified comparison predicate, 298
scalar
BETWEEN predicate , 286
comparison predicate , 288
DELETE statement, 109, 199
IN predicate , 292
NULL predicate, 296
quantified comparison predicate, 298
UPDATE statement, 199
table, 292
SUBSTR function
examples of, 472
operand requirements, 471
syntax diagram of, 471
SUBSTRING function
examples of, 472
operand requirements, 471
syntax diagram of, 471
Suitable keys
Neoview SQL guidelines for selecting, 80
SUM function
DISTINCT clause within, 473
examples of, 473
syntax diagram of, 473
SUM window function
examples of, 505
syntax diagram of, 505
Synonyms
considerations, 43, 117
description of, 309
SYSKEY
definition of, 66
system-defined clustering key, 272
T
Table
creating, 72
description of, 310
dropping, 118
limits, 523
names, reserved, 86
renaming, 47
size, 74
subquery, 292
Table reference
description of, 167
SELECT statement use of, 167
TABLE statement
considerations for, 197
examples, 197
syntax diagram for, 197
Table value constructor
description of, 170
simple table, form of, 170
TAN function
examples of, 474
syntax diagram of, 474
TANH function
examples of, 475
syntax diagram of, 475
THIS function
examples of, 476
syntax diagram of, 476
Timeout values
dynamic, 186
TIMESTAMPADD function
description, 477
examples, 477
TIMESTAMPDIFF function
description, 478
examples, 478
548 Index