SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-20
M
Logical operators
NOT, AND, OR 6-106
search condition use of 6-106
LOWER function
examples of 9-84
syntax diagram of 9-80
LPAD function
examples of 9-85
syntax diagram of 9-85
LS command
examples of 4-52
options 4-51
LTRIM function
examples of 9-88
syntax diagram of 9-88
M
Magnitude 6-53
Management statements, summary of 9-89
MATERIALIZE default 10-76
Math functions
summary of 9-5
ABS 9-10
ACOS 9-10
ASIN 9-12
ATAN 9-13
ATAN2 9-13
CEILING 9-22
COS 9-34
COSH 9-34
DEGREES 9-47
EXP 9-54
FLOOR 9-66
LOG 9-79
LOG10 9-79
MOD 9-92
PI 9-112
POWER 9-114
RADIANS 9-125
Math functions (continued)
SIGN 9-150
SIN 9-151
SINH 9-151
SQRT 9-152
TAN 9-160
TANH 9-160
MAX function
DISTINCT clause within 9-89
examples of 9-89
syntax diagram of 9-89
MAXEXTENTS file attribute
considerations of 8-7
limits C-1
syntax diagram of 8-7
MAX_ESPS_PER_CPU_PER_OP
default 10-66
MAX_ROWS_LOCKED_FOR_STABLE_AC
CESS default 10-54
MDAM_SCAN_METHOD default 10-66
MEMORY_USAGE_SAFETY_NET
default 10-66
Metadata schemas
DEFINITION_SCHEMA_VERSION_ver
num 10-3
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-13
ALL_UIDS 10-8
ASSOC2DS 10-91
CATSYS 10-9
CAT_REFERENCES 10-9
CK_COL_USAGE 10-13
CK_TBL_USAGE 10-13
COLS 10-14
COL_PRIVILEGES 10-18