SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-20
M
MAX function (continued)
syntax diagram of 9-85
MAXEXTENTS file attribute
considerations of 8-7
limits C-1
syntax diagram of 8-7
MAX_ESPS_PER_CPU_PER_OP
default 10-60
MAX_ROWS_LOCKED_FOR_STABLE_AC
CESS default 10-48
MDAM_SCAN_METHOD default 10-60
MEMORY_USAGE_SAFETY_NET
default 10-61
Metadata schemas
DEFINITION_SCHEMA_VERSION_ver
num 10-4
MXCS_SCHEMA 10-6
SYSTEM_DEFAULTS_SCHEMA 10-5
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-84
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-85
DDL_LOCKS 10-18
ENVIRONMENTVALUES 10-86
HISTINTS 10-80
HISTOGRAMS_nodename 10-77
HISTOGRAM_INTERVALS 10-78
HISTOGRM 10-79
KEY_COL_USAGE 10-18
MP_PARTITIONS 10-19
Metadata tables (continued)
NAME2ID 10-86
OBJECTS 10-19
PARTITIONS 10-20
REF_CONSTRAINTS 10-21
REPLICAS 10-22
RESOURCEPOLICIES 10-87
RI_UNIQUE_USAGE 10-22
ROUTINES 10-23
SCHEMATA 10-10
SCHEMA_REPLICAS 10-10
SYSTEM_DEFAULTS 10-31
TBL_CONSTRAINTS 10-24
TBL_PRIVILEGES 10-24
TEXT 10-25
TRIGGERS 10-26
TRIGGERS_CAT_USAGE 10-26
TRIGGERS_USED 10-28
UID identifier 10-4
VWS 10-29
VW_COL_TBLS 10-29
VW_COL_TBL_COLS 10-30
VW_COL_USAGE 10-30
VW_TBL_USAGE 10-30
Metadata, SQL/MP 10-2
migrate utility 5-63
Migrating SQL/MP metadata 10-2
MIN function
DISTINCT clause within 9-86
examples of 9-86
syntax diagram of 9-86
MINUTE function
examples of 9-87
syntax diagram of 9-87
MIN_MAX_OPTIMIZATION default 10-61
MOD function
examples of 9-88
syntax diagram of 9-88
MODE command, syntax diagram of 4-43