Neoview SQL Reference Manual (R2.3)

examples of, 195
materialized aggregate view, definition of, 62
materialized join view
definition of, 62
restrictions for, 64
materialized view
single delta, 63
using other materialized views, 63
materialized views
authorization, 62
clustering, 63
types of, 62
materialized views and indexes, 63
materialized views, restrictions, 64
Math functions
summary of, 292
ABS, 296
ACOS, 297
ASIN, 300
ATAN, 301
ATAN2, 302
CEILING, 311
COS, 319
COSH, 320
DEGREES, 344
EXP, 349
FLOOR, 354
LOG, 363
LOG10, 364
MOD, 375
PI, 393
POWER, 395
RADIANS, 397
SIGN, 415
SIN, 416
SINH, 417
SQRT, 419
TAN, 425
TANH, 426
MAV
restrictions for, 64
MAV, definition of, 62
MAX function
considerations for, 372
DISTINCT clause within, 372
examples of, 372
syntax diagram of, 372
MAX window function
examples of, 450
syntax diagram of, 450
MAXIMUM function
considerations for, 372
DISTINCT clause within, 372
examples of, 372
syntax diagram of, 372
merge from one table to another, 133
MERGE INTO statement
syntax diagram of, 132
MIN function
DISTINCT clause within, 373
examples of, 373
syntax diagram of, 373
MIN window function, 451
examples of, 451
MINUTE function
examples of, 374
syntax diagram of, 374
MJV
definition of, 62
restrictions for, 64
MOD function
examples of, 375
syntax diagram of, 375
MONTH function
examples of, 376
syntax diagram of, 376
MONTHNAME function
examples of, 377
syntax diagram of, 377
MOVINGAVG function
examples of, 378
syntax diagram of, 378
MOVINGCOUNT function
examples of, 379
syntax diagram of, 379
MOVINGMAX function
examples of, 381
syntax diagram of, 381
MOVINGMIN function
examples of, 382
syntax diagram of, 382
MOVINGSTDDEV function
examples of, 383
syntax diagram of, 383
MOVINGSUM function
examples of, 385
syntax diagram of, 385
MOVINGVARIANCE function
examples of, 386
syntax diagram of, 386
MVGROUP, definition of, 264
N
N string literals
character string literals, 233
hexadecimal, 233
NATIONAL CHAR data type, 211
NATIONAL CHAR VARYING data type, 211
National character set
N string literals, 233
NATURAL join, description of, 150
NATURAL LEFT join, description of, 150
NATURAL RIGHT join, description of, 150
NCHAR data type
description of, 211
NCHAR VARYING data type, 211
Neoview SQL objects, logical names, 206
NOT CASESPECIFIC, 73, 258
478 Index