SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-20
M
Metadata schemas (continued)
SYSTEM_SCHEMA 10-3
SYSTEM_SQLJ_SCHEMA 10-7
Metadata tables
ACCESS_PATHS 10-11
ACCESS_PATH_COLS 10-12
ALL_UIDS 10-8
ASSOC2DS 10-79
CATSYS 10-9
CAT_REFERENCES 10-9
CK_COL_USAGE 10-13
CK_TBL_USAGE 10-13
COLS 10-13
COL_PRIVILEGES 10-17
DATASOURCES 10-80
DDL_LOCKS 10-18
ENVIRONMENTVALUES 10-81
HISTINTS 10-75
HISTOGRAMS_nodename 10-72
HISTOGRAM_INTERVALS 10-73
HISTOGRM 10-74
KEY_COL_USAGE 10-18
MP_PARTITIONS 10-19
NAME2ID 10-81
OBJECTS 10-19
PARTITIONS 10-20
REF_CONSTRAINTS 10-21
REPLICAS 10-22
RESOURCEPOLICIES 10-82
RI_UNIQUE_USAGE 10-22
ROUTINES 10-23
SCHEMATA 10-10
SCHEMA_REPLICAS 10-10
SYSTEM_DEFAULTS 10-30
TBL_CONSTRAINTS 10-24
TBL_PRIVILEGES 10-24
TEXT 10-25
TRIGGERS 10-25
TRIGGERS_CAT_USAGE 10-26
Metadata tables (continued)
TRIGGERS_USED 10-27
UID identifier 10-4
VWS 10-28
VW_COL_TBLS 10-28
VW_COL_TBL_COLS 10-29
VW_COL_USAGE 10-29
VW_TBL_USAGE 10-29
Metadata, SQL/MP 10-2
migrate utility 5-42
Migrating SQL/MP metadata 10-2
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-56
MOD function
examples of 9-84
syntax diagram of 9-84
MODE command, syntax diagram of 4-39
MODIFY utility
description of 5-47
hash partitioning 5-53
range partitioning 5-49
reuse range partitions 5-47
system-clustered tables 5-57
MODULE directive
C examples of 3-70
COBOL examples of 3-70
preprocessor use of 3-69
syntax diagram of 3-69
Module management, default
attribute 10-47
MONTH function
examples of 9-85
syntax diagram of 9-85