ALLBASE/SQL Reference Manual (36216-90216)

Index
Index 685
operations with values, 217
storage requirements
, 210
values in arithmetic
expressions
, 218
IS lock
explained
, 179
isolation level
defined
, 185
setting in BEGIN WORK
, 312
settinginSETTRANSACTION
,
542
ISQL
defined
, 42
EXECUTE PROCEDURE in
,
153
using to issue statements
, 87
IX lock
explained
, 179
J
join
algorithmspecifiedbySETOPT
,
531
asymmetric
, 127
in complex queries
, 116
inner and outer
, 509
natural
, 512
nested loop
, 531
not using explicit join syntax
,
514
outer join
, 130
sort merge
, 531
symmetric
, 127
three or more tables
, 513
JOIN ON
in SELECT
, 510
JOIN USING
in SELECT
, 511, 513
joining tables
in SELECT
, 511
in simple queries
, 112
K
keys
index
, 335
L
Labeled Statement
, 458
LANG = clause
for columns and tables
, 67
in ALTER TABLE
, 301
in CREATE TABLE
, 67, 354
in START DBE NEW
, 60, 555,
556
LANG variable
setting and resetting
, 58
language
current language
, 58
DBEnvironment and current
,
60
native language support
, 57
setting and resetting
, 58
LEFT JOIN
in SELECT
, 513
LEFT OUTER JOIN
in SELECT
, 510
left outer join
defined
, 127
LIKE predicate
in search condition
, 262
syntax
, 272
local variable
andDECLARE%%Variable%%
,
376
differences from host variables
,
150
naming rules
, 205
using in procedures
, 150
LOCK TABLE
syntax
, 460
locking
automatic
, 181, 354
concurrency control
, 167
deadlocks
, 195
exclusive mode
, 182, 460
explicit
, 181, 460
granularity
, 179
implicit
, 181
in COMMIT WORK
, 323
in LOCK TABLE
, 460
isolation levels
, 185
levels of
, 181
mode
, 64, 181, 182
mode associated authorities
, 64
mode types of
, 65
objects locked
, 181
overriding automatic locking
,
460
page and table compared
, 177
PUBLIC
, 183
PUBLICREAD
, 183
release
, 188
released in deadlock
, 195
released in STOP DBE
, 571
releasing in ROLLBACK
WORK
, 495
row and page compared
, 177
SET USER TIMEOUT
, 548
share
, 179, 182, 460
share update mode
, 460
locks
exclusive (X)
, 179
in RELEASE
, 479
intention exclusive (IX)
, 179
intention share (IS)
, 179
share (S)
, 179
share intention exclusive (SIX)
,
179
waits and timeout
, 194
log buffer pages
in START DBE
, 552
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
log buffers
flushing
, 316
LOG COMMENT
syntax
, 462
log comment
generating
, 462
log file
creating new
, 563
defined
, 47
increasing or decreasing space
,
567
orphaned, in wrapperDBE
, 92
log file names
assigning
, 560
in START DBE NEWLOG
, 563
rules for
, 201
logging
audit
, 91, 555, 563
dual
, 555, 563
rollback
, 495
row level DML atomicity
, 144
logical operators
, 262
LONG
I/O string syntax
, 222
LONG BINARY
defined
, 208
storage requirements
, 210
long column
authorization in ALTER
TABLE
, 306, 307
authorization in CREATE
TABLE
, 362
LONG data type
restrictedfromsearchcondition
,
263
syntax, defining column
, 221
LONG VARBINARY
defined
, 208
storage requirements
, 210
M
maximum
columns
, 357
columns for a view
, 367
columns in a query
, 512
concurrent transactions
, 553,
556, 564