Neoview SQL Reference Manual (R2.4 SP2)

J
Join
CROSS, 168
FULL, 169
JOIN ON, 168
join predicate, 178
LEFT, 169
limits, 173
NATURAL, 168
NATURAL FULL, 168
NATURAL LEFT, 168
NATURAL RIGHT, 168
optional specifications, 168
RIGHT, 169
types, 168
JOIN ON join, description of, 168
JULIANTIMESTAMP function
examples of, 397
syntax diagram of, 397
K
Keys
clustering, 260
hash partition, 260
index, 260
primary, 260
L
LARGEINT data type, 241
LASTNOTNULL function
examples of, 398
syntax diagram of, 398
LCASE function
examples of, 399
syntax diagram of, 399
LEFT function
examples of, 400
syntax diagram of, 400
LEFT join, description of, 169
LIKE predicate
considerations for, 281
syntax of, 281
Limits
constraints, 511
IN predicate, 279
indexes, 62, 511
number of tables joined, 173
tables, 86, 511
Literals
datetime, examples of, 263
description of, 261
examples of, 261
interval, examples of, 266
numeric, examples of, 267
LOAD IF EXISTS, 84
Loading data into tables
LOAD IF EXISTS option, 84
LOCATE function
examples of, 401
result of, 401
syntax diagram of, 401
Lock modes
EXCLUSIVE mode, 148
LOCK TABLE effect on, 148
SELECT statement use of, 171
SHARE mode, 148
types of, 171
using, 172
LOCK TABLE statement
and indexes, 149
AUTOCOMMIT option, 148
considerations for, 148
examples of, 149
EXCLUSIVE mode, 148
modify default locking, 148
SHARE mode, 148
syntax diagram of, 148
Lock timeout
dynamic, SET TABLE TIMEOUT statement setting,
185
Locking
AUTOCOMMIT option, 148
duration, 27
escalation, 27
EXCLUSIVE lock mode, 27, 148
granularity, 27
holder, 28
LOCK TABLE statement, 27, 148
modes, 27
modifying default, 148
READ COMMITTED access option, 26
release of, 28
REPEATABLE READ access option, 26
SELECT statement, 27
SERIALIZABLE access option, 26, 27, 33
SHARE lock mode, 27, 148
LOG function
examples of, 402
syntax diagram of, 402
LOG10 function
examples of, 403
syntax diagram of, 403
Logical name
Neoview SQL objects, 230
Logical operators
NOT, AND, OR, 292
search condition use of, 292
Long running delete, 108
LOWER function
examples of, 404
syntax diagram of, 404
LPAD function
examples of, 405
syntax diagram of, 405
LTRIM function
examples of, 406
syntax diagram of, 406
530 Index