SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)
Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-21
M
Metadata tables
ACCESS_PATHS 10-13
ACCESS_PATH_COLS 10-15
ALL_UIDS 10-8
ASSOC2DS 10-97
CATSYS 10-9
CAT_REFERENCES 10-9
CK_COL_USAGE 10-15
CK_TBL_USAGE 10-16
COLS 10-16
COL_PRIVILEGES 10-21
DATASOURCES 10-98
DDL_LOCKS 10-22
DDL_PARTITION_LOCKS 10-22
ENVIRONMENTVALUES 10-99
HISTINTS 10-93
HISTOGRAMS_nodename 10-89
HISTOGRAM_INTERVALS 10-91
HISTOGRM 10-92
KEY_COL_USAGE 10-23
MP_PARTITIONS 10-23
NAME2ID 10-99
OBJECTS 10-24
PARTITIONS 10-25
REF_CONSTRAINTS 10-26
REPLICAS 10-27
RESOURCEPOLICIES 10-100
RI_UNIQUE_USAGE 10-27
ROUTINES 10-28
SCHEMATA 10-10
SCHEMA_REPLICAS 10-11
SYSTEM_DEFAULTS 10-38
TBL_CONSTRAINTS 10-31
TBL_PRIVILEGES 10-32
TEXT 10-33
TRIGGERS 10-33
TRIGGERS_CAT_USAGE 10-35
TRIGGERS_USED 10-35
UID identifier 10-3
VWS 10-36
VW_COL_TBL_COLS 10-37
VW_COL_USAGE 10-37
VW_TBL_USAGE 10-37
MGM_PRIVILEGES 10-12
migrate utility 5-79
MIN function
DISTINCT clause within 9-104
examples of 9-104
syntax diagram of 9-104
MINUTE function
examples of 9-105
syntax diagram of 9-105
MIN_MAX_OPTIMIZATION default 10-72
MOD function
examples of 9-106
syntax diagram of 9-106
MODE command, syntax diagram of 4-54
MODIFY utility
description of 5-79
hash partitioning 5-87
range partitioning 5-81
reuse range partitions 5-79
system-clustered tables 5-92
MODULE directive
C examples of 3-71
COBOL examples of 3-71
preprocessor use of 3-70
syntax diagram of 3-70
Module management, default
attribute 10-61
MONTH function
examples of 9-107
syntax diagram of 9-107
MONTHNAME function
examples of 9-108
syntax diagram of 9-108
MOVINGAVG function
examples of 9-110
syntax diagram of 9-109










