Neoview SQL Reference Manual (R2.4 SP2)

summary of, 329
DIFF1, 384
DIFF2, 386
LASTNOTNULL, 398
MOVINGAVG, 413
MOVINGCOUNT, 414
MOVINGMAX, 415
MOVINGMIN, 416
MOVINGSTDDEV, 417
MOVINGSUM, 419
MOVINGVARIANCE, 420
OFFSET, 426
RANK/RUNNINGRANK, 432
ROWS SINCE, 439
ROWS SINCE CHANGED, 441
RUNNINGAVG, 444
RUNNINGCOUNT, 445
RUNNINGMAX, 446
RUNNINGMIN, 447
RUNNINGSTDDEV, 448
RUNNINGSUM, 449
RUNNINGVARIANCE, 450
THIS, 464
Sequence-generating column, 76
Sequence-generator table
recalibrating the current value, 49, 83
SERIALIZABLE, 26, 27, 33
Set functions, 325
SET ON ROLLBACK clause
DELETE description of, 107
UPDATE description of, 198
SET PARAM command, 119
SET SCHEMA statement
example of, 184
scope of, 184
syntax, 184
SET TABLE TIMEOUT statement
considerations for, 186
examples of, 186
syntax diagram of, 185
SET TRANSACTION statement
concurrency, 190
considerations for, 189
examples of, 191
explicit transactions, 190
implicit transactions, 190
MULTI COMMIT, 189
syntax diagram of, 187
transaction modes set by, 187
SHARE lock mode, 27
SHOWDDL statement, 192
considerations for, 192
differences between output and original DDL, 192
examples of, 193
privileges option, 192
syntax diagram of, 192
Side tree insert
definition of, 61
SIGN function
examples of, 452
syntax diagram of, 452
Simple table, in SELECT statement, 169
SIN function
examples of, 453
syntax diagram of, 453
SINH function
examples of, 454
syntax diagram of, 454
SKIP CONFLICT
publish/subscribe, 26
SELECT statement, 171
SMALLINT data type, 241
SPACE function
examples of, 455
syntax diagram of, 455
SQL statements
ANSI compliant, 33
Neoview SQL extensions, 34
SQL Utilities
MAINTAIN command, 210
POPULATE INDEX utility, 218
PURGEDATA utility, 220
SQL value expression, 243
SQRT function
examples of, 456
syntax diagram of, 456
Standards
ANSI SQL, 513
character set support, 517
ISO, 513
Statement atomicity
automatic, 28
description of, 28
Statements, SQL
ANSI compliant, 33
Neoview SQL extensions, 34
Statistics
clearing, 203
UPDATE STATISTICS statement, 206, 207
STDDEV function
DISTINCT clause within, 457
examples of, 458
statistical definition of, 457
syntax diagram of, 457
STDDEV window function
examples of, 492
syntax diagram of, 492
Stored procedure statements, 39
CALL, 56
GRANT EXECUTE, 137
REVOKE EXECUTE, 157
Stored text
reserved words, 507
Stream timeout
dynamic, SET TABLE TIMEOUT statement setting,
185
String literals, 261
String value expression
535