SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-18
M
Locking (continued)
SERIALIZABLE access option 1-9
SHARE lock mode 1-10
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-72
syntax diagram of 9-72
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-105
search condition use of 6-105
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-51
Management statements, summary of 9-81
MATERIALIZE default 10-64
Math functions
summary of 9-5
Math functions (continued)
ABS 9-10
ACOS 9-11
ASIN 9-13
ATAN 9-14
ATAN2 9-15
CEILING 9-24
COS 9-33
COSH 9-34
DEGREES 9-48
EXP 9-55
FLOOR 9-63
LOG 9-72
LOG10 9-73
MOD 9-84
PI 9-104
POWER 9-107
RADIANS 9-118
SIGN 9-142
SIN 9-143
SINH 9-144
SQRT 9-146
TAN 9-154
TANH 9-155
MAX function
DISTINCT clause within 9-81
examples of 9-81
syntax diagram of 9-81
MAXEXTENTS file attribute
considerations of 8-8
syntax diagram of 8-8
MAX_ESPS_PER_CPU_PER_OP
default 10-55
MAX_ROWS_LOCKED_FOR_STABLE_AC
CESS default 10-45
MDAM_SCAN_METHOD default 10-55
Metadata schemas
DEFINITION_SCHEMA_VERSION_ver
num 10-3
MXCS_SCHEMA 10-5