SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-19
L
Limits (continued)
indexes 2-60, C-1
joins 2-216, C-1
MAXEXTENTS C-1
partitions C-1
referential constraints 2-20, C-2
SELECT statement, FROM clause C-1
tables 2-94, C-2
Literals
character string, examples of 6-67
datetime, examples of 6-70
description of 6-64
examples of 6-64
interval, examples of 6-75
numeric, examples of 6-76
LOCATE function
examples of 9-78
result of 9-77
syntax diagram of 9-77
LOCATION file option
CREATE CATALOG use of 2-52
CREATE INDEX use of 2-56
CREATE VIEW use of 2-113
Lock escalation
description of 1-10
DISPLAY STATISTICS statement 4-23
import utility 5-36
Lock granularity 1-10
Lock modes
LOCK TABLE effect on 2-180
SELECT statement use of 2-173,
2-213
types of 2-173, 2-213
using 2-215
LOCK TABLE statement
examples of 2-181
EXCLUSIVE mode 2-180
SHARE mode 2-180
syntax diagram of 2-180
Lock timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-240
static
CONTROL TABLE statement
setting 2-49
SYSTEM_DEFAULTS table 10-54
Lock waits
DISPLAY STATISTICS statement 4-23
Locking
duration 1-10
EXCLUSIVE lock mode 1-11
granularity 1-10
holder 1-11
lock escalation 1-10, 4-23
LOCK TABLE statement
lock duration 1-10
lock mode 1-11
syntax description of 2-180
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-48
examples of 4-48
log file, contents of 4-48
syntax diagram of 4-47
Log file 4-48
LOG function
examples of 9-79
syntax diagram of 9-79
LOG10 function
examples of 9-79
syntax diagram of 9-79
Logical name
SQL/MP objects 6-14
SQL/MX objects 6-13