Neoview SQL Reference Manual (R2.4)
optional specifications, 168
RIGHT, 168
types, 168
JOIN ON join, description of, 168
JULIANTIMESTAMP function
examples of, 388
syntax diagram of, 388
K
Keys
clustering, 255
index, 255
primary, 255
L
LARGEINT data type, 239
LASTNOTNULL function
examples of, 389
syntax diagram of, 389
LCASE function
examples of, 390
syntax diagram of, 390
LEFT function
examples of, 391
syntax diagram of, 391
LEFT join, description of, 168
LIKE predicate
syntax of, 275
Limits
constraints, 505
IN predicate, 273
indexes, 60, 505
joins, 173
tables, 84, 505
Literals
datetime, examples of, 258
description of, 256
examples of, 256
interval, examples of, 261
numeric, examples of, 262
LOCATE function
examples of, 392
result of, 392
syntax diagram of, 392
Lock modes
LOCK TABLE effect on, 147
SELECT statement use of, 143, 171
types of, 143, 171
using, 172
LOCK TABLE statement
AUTOCOMMIT option, 147
examples of, 148
EXCLUSIVE mode, 147
modify default locking, 147
syntax diagram of, 147
Lock timeout
dynamic, SET TABLE TIMEOUT statement setting,
185
Locking
AUTOCOMMIT option, 147
duration, 29
escalation, 29
EXCLUSIVE lock mode, 29
granularity, 29
holder, 30
LOCK TABLE statement
lock mode, 30
syntax description of, 147
modes, 29
modifying default, 147
release of, 30
SELECT statement, 30
SERIALIZABLE access option, 28, 29, 35
LOG function
examples of, 393
syntax diagram of, 393
LOG10 function
examples of, 394
syntax diagram of, 394
Logical name
Neoview SQL objects, 228
Logical operators
NOT, AND, OR, 286
search condition use of, 286
Long running delete, 107
LOWER function
examples of, 399
syntax diagram of, 395
LPAD function
examples of, 400
syntax diagram of, 400
LTRIM function
examples of, 401
syntax diagram of, 401
M
Magnitude, 251
MAINTAIN command, 210
description of, 211
examples of, 215, 216
multiple table reorg, 214
syntax diagram of, 211
uses, 210
MAINTAIN MVGROUP command, 214
Materialized aggregate view, definition of, 63, 263
Materialized join view
definition of, 63, 263
restrictions for, 65
Materialized views
and indexes, 65
authorization, 64
clustering, 64
described, 263
examples, 66
RECOMPUTE, 64
restrictions, 65
single delta, 64
types of, 63, 263
522 Index