Neoview SQL Reference Manual (R2.2)

joined table within, 147
lock modes, 150
ORDER BY clause , 151, 154
RETURN list, 145
select list elements, 144
SEQUENCE BY clause, 149
simple table within, 147
SKIP CONFLICT access, 150
stream access limitations, 152
STREAM clause, 145
syntax diagram of, 142
table reference within, 145
TRANSPOSE clause, 148
union operation within, 150, 154
views and, 151
WHERE clause, 148
self-referencing INSERT, 123
SEQUENCE BY clause
examples of, 269
SELECT statement use of, 268
syntax diagram of, 268
Sequence functions
summary of, 283
DIFF1, 334
DIFF2, 336
LASTNOTNULL, 347
MOVINGAVG, 367
MOVINGCOUNT, 368
MOVINGMAX, 370
MOVINGMIN, 371
MOVINGSTDDEV, 372
MOVINGSUM, 374
MOVINGVARIANCE, 375
OFFSET, 381
ROWS SINCE, 392
ROWS SINCE CHANGED, 394
RUNNINGAVG, 395
RUNNINGCOUNT, 396
RUNNINGMAX, 397
RUNNINGMIN, 397
RUNNINGSTDDEV, 389, 400
RUNNINGSUM, 401
RUNNINGVARIANCE, 402
THIS, 416
SERIALIZABLE, 31, 36
Set functions, 279
SET ON ROLLBACK clause
DELETE description of, 91
UPDATE description of, 170
SET PARAM command, 101
SET SCHEMA
example of, 163
SET SCHEMA statement
scope of, 163
SET TABLE TIMEOUT statement
syntax diagram of, 164
SET TRANSACTION statement
syntax diagram of, 166
transaction modes set by, 166
SHARE lock mode, 31
SIGN function
examples of, 404
syntax diagram of, 404
Simple table, in SELECT statement, 147
SIN function
examples of, 405
syntax diagram of, 405
SINH function
examples of, 406
syntax diagram of, 406
SKIP CONFLICT
publish/subscribe, 31
SELECT statement, 150
SMALLINT data type, 206
SPACE function
examples of, 407
syntax diagram of, 407
SQL statements
ANSI compliant, 37
Neoview SQL extensions, 38
SQL value expression, 208
SQRT function
examples of, 408
syntax diagram of, 408
Standards
ANSI SQL, 443
character set support, 448
ISO, 443
Statement atomicity
automatic, 32
description of, 32
Statements, SQL
ANSI compliant, 37
Neoview SQL extensions, 38
Statistics
clearing, 175
UPDATE STATISTICS statement
considerations, 177
examples of, 178
STDDEV function
DISTINCT clause within, 409
examples of, 410
statistical definition of, 409
syntax diagram of, 409
Stored procedure statements, 43
CALL, 53
GRANT EXECUTE, 117
REVOKE EXECUTE, 136
Stored text
reserved words, 437
Stream timeout
dynamic, SET TABLE TIMEOUT statement setting,
164
String literals, 223
String value expression
examples of, 208
syntax diagram of, 208
Subquery
459