Neoview SQL Reference Manual (R2.5)

LOWER function
examples of, 416
syntax diagram of, 416
LPAD function
examples of, 417
syntax diagram of, 417
LTRIM function
examples of, 418
syntax diagram of, 418
M
Magnitude, 266
MAINTAIN command
considerations for, 216
description of, 213
examples of, 217, 218
multiple table reorg, 216
OVERRIDE option, 216
syntax diagram of, 213
uses, 212
MAINTAIN MVGROUP command, 217
Materialized aggregate view
definition of, 65, 281
restricitions for, 67
Materialized join view
definition of, 65, 281
restrictions for, 67
Materialized views
and indexes, 66
authorization, 65
clustering, 66
described, 281
examples, 67
RECOMPUTE, 65, 281
restrictions, 67
single delta, 66
types of, 65, 281
using other materialized views, 66
Math functions
summary of, 340
ABS, 344
ACOS, 345
ASIN, 348
ATAN, 349
ATAN2, 350
CEILING, 359
COS, 369
COSH, 370
DEGREES, 395
EXP, 400
FLOOR, 405
LOG, 414
LOG10, 415
MOD, 422
NULLIFZERO, 435
PI, 439
POWER, 441
RADIANS, 443
ROUND, 450
SIGN, 464
SIN, 465
SINH, 466
SQRT, 468
TAN, 474
TANH, 475
ZEROIFNULL, 489
MAV
definition of, 65, 281
restrictions for, 67
MAX function
considerations for, 419
DISTINCT clause within, 419
examples of, 419
syntax diagram of, 419
MAX window function
examples of, 498
syntax diagram of, 498
MAXIMUM function
considerations for, 419
DISTINCT clause within, 419
examples of, 419
syntax diagram of, 419
MERGE INTO statement
considerations for, 151
description of, 151
example of, 153
merge from one table to another, 152
restrictions, 152
syntax diagram of, 151
upsert, single row, 151
MIN function
DISTINCT clause within, 420
examples of, 420
syntax diagram of, 420
MIN window function
examples of, 500
syntax diagram of, 500
MINUTE function
examples of, 421
syntax diagram of, 421
MJV
definition of, 65, 281
restrictions for, 67
MOD function
examples of, 422
syntax diagram of, 422
Mode_special_2, 531
MONTH function
examples of, 423
syntax diagram of, 423
MONTHNAME function
examples of, 424
syntax diagram of, 424
MOVINGAVG function
examples of, 425
syntax diagram of, 425
MOVINGCOUNT function
examples of, 426
543