SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-20
M
log file, contents of 4-48
syntax diagram of 4-47
Log file 4-48
LOG function
examples of 9-93
syntax diagram of 9-93
LOG10 function
examples of 9-93
syntax diagram of 9-93
Logical name
SQL/MP objects 6-14
SQL/MX objects 6-13
Logical operators
NOT, AND, OR 6-106
search condition use of 6-106
LOWER function
examples of 9-98
syntax diagram of 9-94
LPAD function
examples of 9-99
syntax diagram of 9-99
LS command
examples of 4-52
options 4-51
LTRIM function
examples of 9-102
syntax diagram of 9-102
M
Magnitude 6-53
Management statements, summary
of 9-103
MATERIALIZE default 10-82
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-37
COSH 9-37
DEGREES 9-57
EXP 9-65
FLOOR 9-78
LOG 9-93
LOG10 9-93
MOD 9-106
PI 9-130
POWER 9-132
RADIANS 9-143
SIGN 9-168
SIN 9-169
SINH 9-169
SQRT 9-170
TAN 9-178
TANH 9-178
MAX function
DISTINCT clause within 9-103
examples of 9-103
syntax diagram of 9-103
MAXEXTENTS file attribute
considerations of 8-7
limits C-1
syntax diagram of 8-7
MAX_ESPS_PER_CPU_PER_OP
default 10-71
MAX_ROWS_LOCKED_FOR_STABLE_AC
CESS default 10-58
MDAM_SCAN_METHOD default 10-71
MEMORY_USAGE_SAFETY_NET
default 10-72
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