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

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-19
M
LOG command
concurrent MXCI sessions 4-34
examples of 4-35
log file, contents of 4-34
syntax diagram of 4-34
Log file 4-34
LOG function
examples of 9-73
syntax diagram of 9-73
LOG10 function
examples of 9-73
syntax diagram of 9-73
Logical name
SQL/MP objects 6-13
SQL/MX objects 6-12
Logical operators
NOT, AND, OR 6-102
search condition use of 6-102
LOWER function
examples of 9-78
syntax diagram of 9-74
LPAD function
examples of 9-79
syntax diagram of 9-79
LS command
examples of 4-37
options 4-36
LTRIM function
examples of 9-80
syntax diagram of 9-80
M
Magnitude 6-49
Management statements, summary of 9-81
MATERIALIZE default 10-66
Math functions
summary of 9-5
ABS 9-10
ACOS 9-10
Math functions (continued)
ASIN 9-12
ATAN 9-13
ATAN2 9-13
CEILING 9-22
COS 9-31
COSH 9-31
DEGREES 9-44
EXP 9-51
FLOOR 9-60
LOG 9-73
LOG10 9-73
MOD 9-84
PI 9-104
POWER 9-106
RADIANS 9-116
SIGN 9-139
SIN 9-140
SINH 9-140
SQRT 9-141
TAN 9-149
TANH 9-149
MAX function
DISTINCT clause within 9-81
examples of 9-81
syntax diagram of 9-81
MAXEXTENTS file attribute
considerations of 8-7
limits C-1
syntax diagram of 8-7
MAX_ESPS_PER_CPU_PER_OP
default 10-56
MAX_ROWS_LOCKED_FOR_STABLE_AC
CESS default 10-46
MDAM_SCAN_METHOD default 10-56
Metadata schemas
DEFINITION_SCHEMA_VERSION_ver
num 10-4
MXCS_SCHEMA 10-6
SYSTEM_DEFAULTS_SCHEMA 10-5