SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-19
L
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-86, C-1
joins 2-348, C-1
MAXEXTENTS C-1
partitions C-1
referential constraints 2-29, C-2
SELECT statement, FROM clause C-1
tables 2-127, 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 8-92
result of 8-92
syntax diagram of 8-91
LOCATION file option
CREATE CATALOG use of 2-78
CREATE INDEX use of 2-82
CREATE VIEW use of 2-157
Lock escalation
description of 1-11
DISPLAY STATISTICS statement 4-23
import utility 5-23
Lock granularity 1-11
Lock modes
LOCK TABLE effect on 2-268
SELECT statement use of 2-256,
2-345
types of 2-256, 2-345
using 2-347
LOCK TABLE statement
examples of 2-269
EXCLUSIVE mode 2-268
SHARE mode 2-268
syntax diagram of 2-268
Lock timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-372
static
CONTROL TABLE statement
setting 2-75
SYSTEM_DEFAULTS table 10-57
Lock waits
DISPLAY STATISTICS statement 4-23
Locking
duration 1-11
EXCLUSIVE lock mode 1-12
granularity 1-11
holder 1-12
lock escalation 1-11, 4-23
LOCK TABLE statement
lock duration 1-11
lock mode 1-12
syntax description of 2-268
modes 1-12
release of 1-12
SELECT statement 1-12
SERIALIZABLE access option 1-9,
1-11
, 1-24
SHARE lock mode 1-12
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