SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-19
M
Locking
duration 1-10
EXCLUSIVE lock mode 1-11
granularity 1-10
holder 1-11
lock escalation 1-10, 4-22
LOCK TABLE statement
lock duration 1-10
lock mode 1-11
syntax description of 2-179
modes 1-11
release of 1-11
SELECT statement 1-11
SERIALIZABLE access option 1-8,
1-10, 1-22
SHARE lock mode 1-11
LOG command
concurrent MXCI sessions 4-37
examples of 4-37
log file, contents of 4-37
syntax diagram of 4-36
Log file 4-37
LOG function
examples of 9-77
syntax diagram of 9-77
LOG10 function
examples of 9-77
syntax diagram of 9-77
Logical name
SQL/MP objects 6-14
SQL/MX objects 6-13
Logical operators
NOT, AND, OR 6-103
search condition use of 6-103
LOWER function
examples of 9-82
syntax diagram of 9-78
LPAD function
examples of 9-83
syntax diagram of 9-83
LS command
examples of 4-41
options 4-40
LTRIM function
examples of 9-84
syntax diagram of 9-84
M
Magnitude 6-50
Management statements, summary of 9-85
MATERIALIZE default 10-71
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-34
COSH 9-34
DEGREES 9-47
EXP 9-54
FLOOR 9-64
LOG 9-77
LOG10 9-77
MOD 9-88
PI 9-108
POWER 9-110
RADIANS 9-120
SIGN 9-143
SIN 9-144
SINH 9-144
SQRT 9-145
TAN 9-153
TANH 9-153
MAX function
DISTINCT clause within 9-85
examples of 9-85