SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-19
L
LEFT join, description of 2-264
LIKE predicate
CREATE TABLE 2-112
escape character within 6-98
examples of 6-99
NOT within 6-97
syntax diagram of 6-97
wild-card characters within 6-98
Limits
constraints C-1
DROP SCHEMA C-1
extents C-1
IN predicate 6-95, C-1
indexes 2-78, C-1
joins 2-273, C-1
MAXEXTENTS C-1
partitions C-1
referential constraints 2-22, C-2
SELECT statement, FROM clause C-1
tables 2-115, 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-92
result of 9-92
syntax diagram of 9-91
LOCATION file option
CREATE CATALOG use of 2-70
CREATE INDEX use of 2-74
CREATE VIEW use of 2-145
Lock escalation
description of 1-12
DISPLAY STATISTICS statement 4-23
import utility 5-47
Lock granularity 1-12
Lock modes
LOCK TABLE effect on 2-233
SELECT statement use of 2-221,
2-270
types of 2-221, 2-270
using 2-272
LOCK TABLE statement
examples of 2-234
EXCLUSIVE mode 2-233
SHARE mode 2-233
syntax diagram of 2-233
Lock timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-297
static
CONTROL TABLE statement
setting 2-67
SYSTEM_DEFAULTS table 10-58
Lock waits
DISPLAY STATISTICS statement 4-23
Locking
duration 1-12
EXCLUSIVE lock mode 1-13
granularity 1-12
holder 1-13
lock escalation 1-12, 4-23
LOCK TABLE statement
lock duration 1-12
lock mode 1-13
syntax description of 2-233
modes 1-13
release of 1-13
SELECT statement 1-13
SERIALIZABLE access option 1-10,
1-12, 1-24
SHARE lock mode 1-13
LOG command
concurrent MXCI sessions 4-48
examples of 4-48