SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-20
M
Log file 4-48
LOG function
examples of 9-88
syntax diagram of 9-88
LOG10 function
examples of 9-88
syntax diagram of 9-88
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-93
syntax diagram of 9-89
LPAD function
examples of 9-94
syntax diagram of 9-94
LS command
examples of 4-52
options 4-51
LTRIM function
examples of 9-97
syntax diagram of 9-97
M
Magnitude 6-53
Management statements, summary of 9-98
MATERIALIZE default 10-79
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-52
EXP 9-60
FLOOR 9-73
LOG 9-88
LOG10 9-88
MOD 9-101
PI 9-125
POWER 9-127
RADIANS 9-138
SIGN 9-163
SIN 9-164
SINH 9-164
SQRT 9-165
TAN 9-173
TANH 9-173
MAX function
DISTINCT clause within 9-98
examples of 9-98
syntax diagram of 9-98
MAXEXTENTS file attribute
considerations of 8-7
limits C-1
syntax diagram of 8-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-69
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-12