ALLBASE/SQL Reference Manual (36216-90216)

688 Index
Index
syntax (SELECT), 499
R
RAISE ERROR
in procedures
, 155
in procedures invoked by rules
,
162
syntax
, 474
RC isolation level
explained
, 175
in SET SESSION
, 537
in SET TRANSACTION
, 543
read committed (RC)
explained
, 175
read committed isolation level
in BEGIN WORK
, 312
in SET SESSION
, 537
in SET TRANSACTION
, 542
read uncommitted (RU)
explained
, 176
read uncommitted isolation level
in BEGIN WORK
, 312
in SET SESSION
, 537
in SET TRANSACTION
, 543
REAL
conversions rules
, 504
data type defined
, 208
storage requirements
, 210
recovery
rollback
, 495
referenced table
defined
, 138
referencing table
defined
, 139
referential constraint
deferred error checking
, 144
defined
, 138
in ALTER TABLE
, 301
in CREATE TABLE
, 354
revoking
, 489
slowing TRUNCATE TABLE
,
578
referential integrity
using constraints
, 68, 137
REFETCH
syntax
, 476
relation
defined
, 44
relational database
defined
, 44
RELEASE
syntax
, 479
release
DBE session
, 479
in COMMIT WORK
, 323
remote connections
establishment of
, 95
REMOVE DBEFile
syntax
, 480
REMOVE FROM GROUP
syntax
, 482
removing DBEFiles
, 480
RENAME COLUMN
syntax
, 484
RENAME TABLE
syntax
, 485
renaming
columns
, 484
tables
, 485
repeatable read (RR)
explained
, 174
repeatable read isolation level
in BEGIN WORK
, 312
in SET SESSION
, 536
in SET TRANSACTION
, 542
RESET
syntax
, 486
resetting ALLBASE/SQL system
data
, 486
result
table defined
, 49
result columns
in SELECT
, 512
retrieving
data
, 109
rows
, 109, 499
RETURN
syntax
, 487
return status
in DECLARE CURSOR
specifying
, 373
revalidating rows
, 476
REVOKE
and CASCADE
, 77
and grantable privilege
, 77
syntax
, 489
revoking
authorities using REVOKE
, 489
grants using CASCADE
, 77
RIGHT OUTER JOIN
in SELECT
, 513
right outer join
defined
, 127
roll forward
wrapperDBE
, 92
rollback
recovery
, 495
ROLLBACK WORK
, 495
ROLLBACK WORK
in a procedure
, 147
syntax
, 495
row level
DML atomicity
, 526
DML atomicity logging
, 144
locking
, 177
rows
defined
, 44
fetching
, 424
inserting
, 445
joining
, 511
selecting
, 499
RR isolation level
explained
, 174
in SET TRANSACTION
, 543
RU isolation level
explained
, 176
in SET SESSION
, 537
in SET TRANSACTION
, 543
rule
and transaction management
,
163
creating
, 158, 346
defined
, 137
differences from integrity
constraints
, 166
enabling and disabling
, 163
explained
, 157
techniques for using procedures
with
, 159
rules and procedures
chains of
, 159
CREATE PROCEDURE
statement
, 339
CREATE RULE statement
, 346
DISABLE RULES statement
,
390
DROP PROCEDURE
statement
, 404
DROP RULE statement
, 405
ENABLE RULES statement
,
413
TRUNCATETABLEstatement
,
578
using
, 145, 157
RUN authority
granting
, 437
purpose
, 94
run block
in START DBE
, 552
in START DBE NEWLOG
, 563
runtime control block pages
in START DBE
, 552
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
runtime errors
in a procedure
, 155
S
S (SHARE) locks
, 460
S lock
explained
, 179