Manualshelf

Neoview SQL Reference Manual (R2.3)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.3 Software
471472473474475476477478479480
syntax diagram of, 223
ISNULL function
examples of, 357
syntax diagram of, 357
ISO standards, 465
Isolation levels
READ COMMITTED, 36
READ UNCOMMITTED, 36
REPEATABLE READ, 37
SERIALIZABLE, 31, 37
J
Join
CROSS, 150
FULL, 150
JOIN ON, 150
join predicate, 160
LEFT, 150
limits, 155
NATURAL, 150
NATURAL LEFT, 150
NATURAL RIGHT, 150
optional specifications, 150
RIGHT, 150
types, 150
JOIN ON join, description of, 150
JULIANTIMESTAMP function
examples of, 358
syntax diagram of, 358
K
Keys
clustering, 232
index, 232
primary, 232
L
LARGINT data type, 216
LASTNOTNULL function
examples of, 358
syntax diagram of, 358
LCASE function
examples of, 360
syntax diagram of, 360
LEFT function
examples of, 361
syntax diagram of, 361
LEFT join, description of, 150
Limits
constraints, 463
IN predicate, 249
indexes, 59, 463
joins, 155
tables, 463
limits
tables, 75
Literals
character string, examples of, 234
datetime, examples of, 235
description of, 233
examples of, 233
interval, examples of, 238
numeric, examples of, 239
LOCATE function
examples of, 362
result of, 362
syntax diagram of, 362
Lock modes
LOCK TABLE effect on, 130
SELECT statement use of, 126, 153
types of, 126, 153
using, 154
LOCK TABLE statement
examples of, 131
EXCLUSIVE mode, 130
syntax diagram of, 130
Lock timeout
dynamic, SET TABLE TIMEOUT statement setting,
168
Locking
duration, 31
EXCLUSIVE lock mode, 31
granularity, 31
holder, 32
LOCK TABLE statement
lock mode, 32
syntax description of, 130
modes, 31
release of, 32
SELECT statement, 32
SERIALIZABLE access option, 31, 37
LOG function
examples of, 363
syntax diagram of, 363
LOG10 function
examples of, 364
syntax diagram of, 364
Logical name
Neoview SQL objects, 206
Logical operators
NOT, AND, OR, 258
search condition use of, 258
long running delete, 93
LOWER function
examples of, 369
syntax diagram of, 365
LPAD function
examples of, 370
syntax diagram of, 370
LTRIM function
examples of, 371
syntax diagram of, 371
M
Magnitude, 228
MAINTAIN command, 192
MAINTAIN MVGROUP command, 194
MAINTAIN utility
477