SQL/MX 2.x Reference Manual (G06.24+, H06.03+)
Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-19
M
Metadata schemas (continued)
SYSTEM_DEFAULTS_SCHEMA 10-5
SYSTEM_SCHEMA 10-3
SYSTEM_SQLJ_SCHEMA 10-6
Metadata tables
ACCESS_PATHS 10-10
ACCESS_PATH_COLS 10-11
ALL_UIDS 10-7
ASSOC2DS 10-77
CATSYS 10-8
CAT_REFERENCES 10-8
CK_COL_USAGE 10-12
CK_TBL_USAGE 10-12
COLS 10-12
COL_PRIVILEGES 10-16
DATASOURCES 10-78
DDL_LOCKS 10-17
ENVIRONMENTVALUES 10-79
HISTINTS 10-73
HISTOGRAMS_nodename 10-70
HISTOGRAM_INTERVALS 10-71
HISTOGRM 10-72
KEY_COL_USAGE 10-17
MP_PARTITIONS 10-18
NAME2ID 10-79
OBJECTS 10-18
PARTITIONS 10-19
REF_CONSTRAINTS 10-20
REPLICAS 10-21
RESOURCEPOLICIES 10-80
RI_UNIQUE_USAGE 10-21
ROUTINES 10-22
SCHEMATA 10-9
SCHEMA_REPLICAS 10-9
SYSTEM_DEFAULTS 10-29
TBL_CONSTRAINTS 10-23
TBL_PRIVILEGES 10-23
TEXT 10-24
TRIGGERS 10-24
Metadata tables (continued)
TRIGGERS_CAT_USAGE 10-25
TRIGGERS_USED 10-26
UID identifier 10-4
VWS 10-27
VW_COL_TBLS 10-27
VW_COL_TBL_COLS 10-28
VW_COL_USAGE 10-28
VW_TBL_USAGE 10-28
MIGRATE utility 5-38
MIN function
DISTINCT clause within 9-82
examples of 9-82
syntax diagram of 9-82
MINUTE function
examples of 9-83
syntax diagram of 9-83
MIN_MAX_OPTIMIZATION default 10-55
MOD function
examples of 9-84
syntax diagram of 9-84
MODE command, syntax diagram of 4-39
MODIFY utility
description of 5-43
hash partitioning 5-49
range partitioning 5-45
reuse range partitions 5-43
system-clustered tables 5-53
MODULE directive
C examples of 3-72
COBOL examples of 3-72
customizer use of 3-72
preprocessor use of 3-71
syntax diagram of 3-71
Module management, default
attribute 10-46
MONTH function
examples of 9-85
syntax diagram of 9-85