SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-17
L
Keys (continued)
primary 6-61
SYSKEY 6-61
Key-sequenced table 1-30
KEY_COL_USAGE metadata table 10-17
KSC5601 character set 6-3
L
LARGINT data type 6-34
LASTNOTNULL function
examples of 9-67
syntax diagram of 9-67
LCASE function
examples of 9-68
syntax diagram of 9-68
LEFT function
examples of 9-69
syntax diagram of 9-69
LEFT join, description of 2-187
LIKE predicate
CREATE TABLE 2-88
escape character within 6-97
examples of 6-98
NOT within 6-96
syntax diagram of 6-96
wild-card characters within 6-97
Limits
IN predicate 6-94
indexes 2-60
INSERT statement 2-153
joins 2-196
referential constraints 2-20
tables 2-89
Literals
character string, examples of 6-65
datetime, examples of 6-68
description of 6-62
examples of 6-62
interval, examples of 6-73
Literals (continued)
numeric, examples of 6-75
LOCATE function
examples of 9-71
result of 9-70
syntax diagram of 9-70
LOCATION file option
CREATE CATALOG use of 2-52
CREATE INDEX use of 2-56
CREATE VIEW use of 2-107
Lock modes
LOCK TABLE effect on 2-160
SELECT statement use of 2-153,
2-193
types of 2-153, 2-193
using 2-195
LOCK TABLE statement
examples of 2-161
EXCLUSIVE mode 2-160
SHARE mode 2-160
syntax diagram of 2-160
Lock timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-218
static
CONTROL TABLE statement
setting 2-49
SYSTEM_DEFAULTS table 10-45
Locking
duration 1-9
EXCLUSIVE lock mode 1-10
granularity 1-9
holder 1-10
LOCK TABLE statement
lock duration 1-9
lock mode 1-10
syntax description of 2-160
modes 1-9
release of 1-10
SELECT statement 1-10