SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-18
L
LIKE predicate
CREATE TABLE 2-87
escape character within 6-94
examples of 6-95
NOT within 6-93
syntax diagram of 6-93
wild-card characters within 6-94
Limits
constraints C-1
DROP SCHEMA C-1
extents C-1
IN predicate 6-91, C-1
indexes 2-58, C-1
INSERT C-1
INSERT statement 2-149
joins 2-192, C-1
MAXEXTENTS C-1
partitions C-1
referential constraints 2-19, C-2
SELECT statement, FROM clause C-1
tables 2-89, C-2
Literals
character string, examples of 6-63
datetime, examples of 6-66
description of 6-60
examples of 6-60
interval, examples of 6-71
numeric, examples of 6-72
LOCATE function
examples of 9-72
result of 9-71
syntax diagram of 9-71
LOCATION file option
CREATE CATALOG use of 2-50
CREATE INDEX use of 2-54
CREATE VIEW use of 2-106
Lock escalation
description of 1-10
DISPLAY STATISTICS statement 4-22
Lock escalation (continued)
import utility 5-24
Lock granularity 1-10
Lock modes
LOCK TABLE effect on 2-156
SELECT statement use of 2-149,
2-189
types of 2-149, 2-189
using 2-191
LOCK TABLE statement
examples of 2-157
EXCLUSIVE mode 2-156
SHARE mode 2-156
syntax diagram of 2-156
Lock timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-214
static
CONTROL TABLE statement
setting 2-47
SYSTEM_DEFAULTS table 10-46
Lock waits
DISPLAY STATISTICS statement 4-22
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-156
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