SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-18
L
Keys (continued)
SYSKEY 6-60
Key-sequenced table 1-31
KEY_COL_USAGE metadata table 10-18
KSC5601 character set 6-4
L
LARGINT data type 6-33
LASTNOTNULL function
examples of 9-72
syntax diagram of 9-72
LCASE function
examples of 9-73
syntax diagram of 9-73
LEFT function
examples of 9-74
syntax diagram of 9-74
LEFT join, description of 2-206
LIKE predicate
CREATE TABLE 2-93
escape character within 6-95
examples of 6-96
NOT within 6-94
syntax diagram of 6-94
wild-card characters within 6-95
Limits
constraints C-1
DROP SCHEMA C-1
extents C-1
IN predicate 6-92, C-1
indexes 2-62, C-1
INSERT C-1
INSERT statement 2-172
joins 2-215, C-1
MAXEXTENTS C-1
partitions C-1
referential constraints 2-20, C-2
SELECT statement, FROM clause C-1
tables 2-95, C-2
Literals
character string, examples of 6-64
datetime, examples of 6-67
description of 6-61
examples of 6-61
interval, examples of 6-72
numeric, examples of 6-73
LOCATE function
examples of 9-76
result of 9-75
syntax diagram of 9-75
LOCATION file option
CREATE CATALOG use of 2-54
CREATE INDEX use of 2-58
CREATE VIEW use of 2-112
Lock escalation
description of 1-10
DISPLAY STATISTICS statement 4-22
import utility 5-32
Lock granularity 1-10
Lock modes
LOCK TABLE effect on 2-179
SELECT statement use of 2-172,
2-212
types of 2-172, 2-212
using 2-214
LOCK TABLE statement
examples of 2-180
EXCLUSIVE mode 2-179
SHARE mode 2-179
syntax diagram of 2-179
Lock timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-237
static
CONTROL TABLE statement
setting 2-51
SYSTEM_DEFAULTS table 10-48
Lock waits
DISPLAY STATISTICS statement 4-22