Neoview SQL Reference Manual (R2.5)

syntax diagram of, 408
ISO standards, 525
Isolation levels
guidelines for CREATE VIEW, 103
READ COMMITTED, 32
READ UNCOMMITTED, 32
REPEATABLE READ, 33
SERIALIZABLE, 26, 27, 33
J
Join
CROSS, 169
FULL, 170
JOIN ON, 169
join predicate, 179
LEFT, 170
limits, 174
NATURAL, 169
NATURAL FULL, 169
NATURAL LEFT, 169
NATURAL RIGHT, 169
optional specifications, 169
RIGHT, 170
types, 169
JOIN ON join, description of, 169
JULIANTIMESTAMP function
examples of, 409
syntax diagram of, 409
K
Keys
clustering, 272
hash partition, 273
index, 273
primary, 273
SYSKEY, 272
L
LARGEINT data type, 253
LASTNOTNULL function
examples of, 410
syntax diagram of, 410
LCASE function
examples of, 411
syntax diagram of, 411
LEFT function
examples of, 412
syntax diagram of, 412
LEFT join, description of, 170
LIKE predicate
considerations for, 294
syntax of, 294
Limits
constraints, 523
IN predicate, 292
indexes, 62, 523
number of tables joined, 174
tables, 87, 523
Literals
datetime, examples of, 276
description of, 274
examples of, 274
interval, examples of, 279
numeric, examples of, 280
LOAD IF EXISTS, 84
Loading data into tables
LOAD IF EXISTS option, 84
LOCATE function
examples of, 413
result of, 413
syntax diagram of, 413
Lock modes
EXCLUSIVE mode, 149
LOCK TABLE effect on, 149
SELECT statement use of, 172
SHARE mode, 149
types of, 172
using, 173
LOCK TABLE statement
and indexes, 150
AUTOCOMMIT option, 149
considerations for, 149
examples of, 150
EXCLUSIVE mode, 149
modify default locking, 149
SHARE mode, 149
syntax diagram of, 149
Lock timeout
dynamic, SET TABLE TIMEOUT statement setting,
186
Locking
AUTOCOMMIT option, 149
duration, 27
escalation, 27
EXCLUSIVE lock mode, 27, 149
granularity, 27
holder, 27
LOCK TABLE statement, 27, 149
modes, 27
modifying default, 149
READ COMMITTED access option, 26
release of, 27
REPEATABLE READ access option, 26
SELECT statement, 27
SERIALIZABLE access option, 26, 27, 33
SHARE lock mode, 27, 149
LOG function
examples of, 414
syntax diagram of, 414
LOG10 function
examples of, 415
syntax diagram of, 415
Logical name
Neoview SQL objects, 242
Logical operators
NOT, AND, OR, 305
search condition use of, 305
Long running delete, 110
542 Index