Neoview SQL Reference Manual (R2.5)

DISTINCT clause , 166
embedded delete, 168
embedded insert, 169
embedded update, 168, 169
examples of, 178
FROM clause , 167
GROUP BY clause , 171, 175
HAVING clause, 172
joined table within, 169
limit on join tables, 174
lock modes, 172
ORDER BY clause , 173, 176
RETURN list, 168
select list elements, 166
SEQUENCE BY clause, 171
simple table within, 170
SKIP CONFLICT access, 172
stream access limitations, 174
STREAM clause, 167
syntax diagram of, 164
TRANSPOSE clause, 171
UNION ALL operation, 177
union operation within, 172, 176
updating rows, 173
views and, 174
WHERE clause, 170
Self-referencing INSERT, 145
SEQUENCE BY clause
examples of, 327
SELECT statement use of, 326
syntax diagram of, 326
Sequence functions
summary of, 341
DIFF1, 396
DIFF2, 398
LASTNOTNULL, 410
MOVINGAVG, 425
MOVINGCOUNT, 426
MOVINGMAX, 427
MOVINGMIN, 428
MOVINGSTDDEV, 429
MOVINGSUM, 431
MOVINGVARIANCE, 432
OFFSET, 438
RANK/RUNNINGRANK, 444
ROWS SINCE, 451
ROWS SINCE CHANGED, 453
RUNNINGAVG, 456
RUNNINGCOUNT, 457
RUNNINGMAX, 458
RUNNINGMIN, 459
RUNNINGSTDDEV, 460
RUNNINGSUM, 461
RUNNINGVARIANCE, 462
THIS, 476
Sequence-generating column, 76
Sequence-generator table
recalibrating the current value, 49, 83
SERIALIZABLE, 26, 27, 33
Set functions, 337
SET ON ROLLBACK clause
DELETE description of, 109
UPDATE description of, 199
SET PARAM command, 121
SET SCHEMA statement
example of, 185
scope of, 185
syntax, 185
SET TABLE TIMEOUT statement
considerations for, 187
examples of, 187
syntax diagram of, 186
SET TRANSACTION statement
concurrency, 191
considerations for, 190
examples of, 192
explicit transactions, 191
implicit transactions, 191
MULTI COMMIT, 190
syntax diagram of, 188
transaction modes set by, 188
SHARE lock mode, 27
SHOWDDL statement, 193
considerations for, 193
differences between output and original DDL, 193
examples of, 194
privileges option, 193
syntax diagram of, 193
Side tree insert
definition of, 61
SIGN function
examples of, 464
syntax diagram of, 464
Simple table, in SELECT statement, 170
SIN function
examples of, 465
syntax diagram of, 465
SINH function
examples of, 466
syntax diagram of, 466
SKIP CONFLICT
publish/subscribe, 26
SELECT statement, 172
SMALLINT data type, 253
SPACE function
examples of, 467
syntax diagram of, 467
SQL statements
ANSI compliant, 33
Neoview SQL extensions, 34
SQL Utilities
MAINTAIN command, 212
POPULATE INDEX utility, 220
PURGEDATA utility, 222
REPLICATE command, 224
SQL value expression, 255
SQRT function
examples of, 468
547