Neoview SQL Reference Manual (R2.4 SP2)

syntax diagram of, 469
Union operation
associative, UNION ALL, 176
columns, characteristics of, 175
ORDER BY clause restriction, 176
SELECT statement use of, 171
Updatable view, requirements for, 102
UPDATE statement
authorization requirements, 199
conflicting updates, 200
description of, 197
examples of, 201
isolation levels, 200
performance, 199
SET clause, 198
SET ON ROLLBACK clause, 198
SKIP CONFLICT access, 199
syntax diagram of, 197
WHERE clause, 199
UPDATE STATISTICS statement
column groups, 204
column lists, 204
considerations, 206
examples of, 207
histogram tables, 204
syntax diagram of, 203
UPPER function
examples of, 470
syntax diagram of, 470
Upsert
using single row, 150
UPSHIFT function
syntax diagram of, 471
USER function
example of, 472
syntax diagram of, 472
Utilities
MAINTAIN command, 210
POPULATE INDEX utility, 218
PURGEDATA utility, 220
V
Value expressions, 243
summary of, 331
CASE (Conditional) expression, 342
CAST expression, 345
VALUES statement
considerations for, 208
examples, 208
syntax diagram for, 208
VARCHAR data type, 236
Variable-length character column, 236
VARIANCE function
DISTINCT clause within, 473
examples of, 474
statistical definition of, 473
syntax diagram of, 473
VARIANCE window function
examples of, 495
syntax diagram of, 495
Vertical partition
example, 105
FOREIGN KEY constraint, 105
Views
CREATE VIEW statement, 101
description of, 299
DROP VIEW statement, 118
relationship to tables, 297
updatability requirements, 102
Volatile tables
considerations, 79
examples, 81, 92
nullable constraints, 80
nullable keys, 79
nullable primary key, 81
suitable keys, 80
W
WEEK function
example of, 475
syntax diagram of, 475
window functions
AVG , 481
considerations, 479
COUNT , 483
DENSE_RANK , 485
limitations, 480
MAX , 486
MIN , 488
ORDER BY clause, use of, 479
RANK , 490
ROW_NUMBER, 491
STDDEV, 492
SUM, 493
VARIANCE, 495
Y
YEAR function
examples of, 476
syntax diagram of, 476
Z
ZEROIFNULL function
example of, 477
syntax diagram of, 477
537