Neoview SQL Reference Manual (R2.2)

table row count, 177
UPPER function
examples of, 427
syntax diagram of, 427
upsert
using rowsets, 130
using single row, 129
upsert functionality, 129
UPSHIFT function
syntax diagram of, 428
USER function
example of, 429
syntax diagram of, 429
Utilities
privileges required to execute, 181
PURGEDATA, 187
V
Value expression, 208
Value expressions
summary of, 285
CASE (Conditional) expression, 295
CAST expression, 298
VARCHAR data type, 201
Variable-length character column, 201
VARIANCE function
DISTINCT clause within, 430
examples of, 431
statistical definition of, 430
syntax diagram of, 430
Views
CREATE VIEW statement, 87
description of, 254
DROP VIEW statement, 100
relationship to tables, 252
updatability requirements, 89
W
WEEK function
syntax diagram of, 432
Y
YEAR function
examples of, 433
syntax diagram of, 433
Z
ZEROIFNULL function
syntax diagram of, 434
461