Neoview SQL Reference Manual (R2.4 SP2)

M
Magnitude, 254
MAINTAIN command
considerations for, 214
description of, 211
examples of, 215, 216
multiple table reorg, 214
syntax diagram of, 211
uses, 210
MAINTAIN MVGROUP command, 215
Materialized aggregate view
definition of, 65, 268
restricitions for, 67
Materialized join view
definition of, 65, 268
restrictions for, 67
Materialized views
and indexes, 66
authorization, 65
clustering, 66
described, 268
examples, 67
RECOMPUTE, 65, 268
restrictions, 67
single delta, 66
types of, 65, 268
using other materialized views, 66
Math functions
summary of, 328
ABS, 332
ACOS, 333
ASIN, 336
ATAN, 337
ATAN2, 338
CEILING, 347
COS, 357
COSH, 358
DEGREES, 383
EXP, 388
FLOOR, 393
LOG, 402
LOG10, 403
MOD, 410
NULLIFZERO, 423
PI, 427
POWER, 429
RADIANS, 431
ROUND, 438
SIGN, 452
SIN, 453
SINH, 454
SQRT, 456
TAN, 462
TANH, 463
ZEROIFNULL, 477
MAV
definition of, 65, 268
restrictions for, 67
MAX function
considerations for, 407
DISTINCT clause within, 407
examples of, 407
syntax diagram of, 407
MAX window function
examples of, 486
syntax diagram of, 486
MAXIMUM function
considerations for, 407
DISTINCT clause within, 407
examples of, 407
syntax diagram of, 407
MERGE INTO statement
considerations for, 150
description of, 150
example of, 152
merge from one table to another, 151
restrictions, 151
syntax diagram of, 150
upsert, single row, 150
MIN function
DISTINCT clause within, 408
examples of, 408
syntax diagram of, 408
MIN window function
examples of, 488
syntax diagram of, 488
MINUTE function
examples of, 409
syntax diagram of, 409
MJV
definition of, 65, 268
restrictions for, 67
MOD function
examples of, 410
syntax diagram of, 410
Mode_special_2, 519
MONTH function
examples of, 411
syntax diagram of, 411
MONTHNAME function
examples of, 412
syntax diagram of, 412
MOVINGAVG function
examples of, 413
syntax diagram of, 413
MOVINGCOUNT function
examples of, 414
syntax diagram of, 414
MOVINGMAX function
examples of, 415
syntax diagram of, 415
MOVINGMIN function
examples of, 416
syntax diagram of, 416
MOVINGSTDDEV function
examples of, 417
syntax diagram of, 417
MOVINGSUM function
531