SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-20
M
LOG function
examples of 8-93
syntax diagram of 8-93
LOG10 function
examples of 8-93
syntax diagram of 8-93
Logical name
SQL/MP objects 6-14
SQL/MX objects 6-13
Logical operators
NOT, AND, OR 6-108
search condition use of 6-108
LOWER function
examples of 8-98
syntax diagram of 8-94
LPAD function
examples of 8-99
syntax diagram of 8-99
LS command
examples of 4-52
options 4-51
LTRIM function
examples of 8-102
syntax diagram of 8-102
M
Magnitude 6-53
Management statements, summary
of 8-103
MATERIALIZE default 10-80
Math functions
summary of 8-5
ABS 8-10
ACOS 8-10
ASIN 8-12
ATAN 8-13
ATAN2 8-13
CEILING 8-22
COS 8-37
COSH 8-37
DEGREES 8-57
EXP 8-65
FLOOR 8-78
LOG 8-93
LOG10 8-93
MOD 8-106
PI 8-130
POWER 8-132
RADIANS 8-143
SIGN 8-168
SIN 8-169
SINH 8-169
SQRT 8-170
TAN 8-178
TANH 8-178
MAX function
DISTINCT clause within 8-103
examples of 8-103
syntax diagram of 8-103
MAXEXTENTS file attribute
considerations of 9-7
limits C-1
syntax diagram of 9-7
MAX_ESPS_PER_CPU_PER_OP
default 10-69
MAX_ROWS_LOCKED_FOR_STABLE_AC
CESS default 10-57
MDAM_SCAN_METHOD default 10-69
MEMORY_USAGE_SAFETY_NET
default 10-70
Metadata schemas
DEFINITION_SCHEMA_VERSION_ver
num 10-3
MXCS_SCHEMA 10-5
SYSTEM_DEFAULTS_SCHEMA 10-5
SYSTEM_SCHEMA 10-3
SYSTEM_SQLJ_SCHEMA 10-6
Metadata tables
ACCESS_PATHS 10-12
ACCESS_PATH_COLS 10-14