SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-19
L
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-77, C-1
joins 2-260, 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-87
result of 9-87
syntax diagram of 9-86
LOCATION file option
CREATE CATALOG use of 2-69
CREATE INDEX use of 2-73
CREATE VIEW use of 2-144
Lock escalation
description of 1-11
DISPLAY STATISTICS statement 4-23
import utility 5-41
Lock granularity 1-11
Lock modes
LOCK TABLE effect on 2-221
SELECT statement use of 2-213,
2-257
types of 2-213, 2-257
using 2-259
LOCK TABLE statement
examples of 2-222
EXCLUSIVE mode 2-221
SHARE mode 2-221
syntax diagram of 2-221
Lock timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-284
static
CONTROL TABLE statement
setting 2-66
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-221
modes 1-12
release of 1-12
SELECT statement 1-12
SERIALIZABLE access option 1-9,
1-11, 1-23
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