was holding at the time of a subsystem
failure. The lock is retained in the
coupling facility lock structure across a
DB2 for z/OS failure.
RID See record identifier.
RID pool
See record identifier pool.
right outer join
The result of a join operation that
includes the matched rows of both tables
that are being joined and preserves the
unmatched rows of the second join
operand. See also join, equijoin, full outer
join, inner join, left outer join, and outer
join.
RLF See resource limit facility.
RLST See resource limit specification table.
role A database entity that groups together
one or more privileges and that can be
assigned to a primary authorization ID or
to PUBLIC. The role is available only in a
trusted context.
rollback
The process of restoring data that was
changed by SQL statements to the state at
its last commit point. All locks are freed.
Contrast with commit.
root page
The index page that is at the highest level
(or the beginning point) in an index.
routine
A database object that encapsulates
procedural logic and SQL statements, is
stored on the database server, and can be
invoked from an SQL statement or by
using the CALL statement. The main
classes of routines are procedures and
functions.
row The horizontal component of a table. A
row consists of a sequence of values, one
for each column of the table.
row identifier (ROWID)
A value that uniquely identifies a row.
This value is stored with the row and
never changes.
row lock
A lock on a single row of data.
row-positioned fetch orientation
The specification of the desired placement
of the cursor as part of a FETCH
statement, with respect to a single row
(for example, NEXT, LAST, or ABSOLUTE
n). Contrast with rowset-positioned fetch
orientation.
rowset
A set of rows for which a cursor position
is established.
rowset cursor
A cursor that is defined so that one or
more rows can be returned as a rowset
for a single FETCH statement, and the
cursor is positioned on the set of rows
that is fetched.
rowset-positioned fetch orientation
The specification of the desired placement
of the cursor as part of a FETCH
statement, with respect to a rowset (for
example, NEXT ROWSET, LAST
ROWSET, or ROWSET STARTING AT
ABSOLUTE n). Contrast with
row-positioned fetch orientation.
row trigger
A trigger that is defined with the trigger
granularity FOR EACH ROW.
RRSAF
See Recoverable Resource Manager
Services attachment facility.
RS See read stability.
savepoint
A named entity that represents the state
of data and schemas at a particular point
in time within a unit of work.
SBCS See single-byte character set.
SCA See shared communications area.
scalar function
An SQL operation that produces a single
value from another value and is
expressed as a function name, followed
by a list of arguments that are enclosed in
parentheses.
scale In SQL, the number of digits to the right
of the decimal point (called the precision
in the C language). The DB2 information
uses the SQL definition.
schema
The organization or structure of a
database.
546 Application Programming Guide and Reference for Java
™
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
To Next Page
Loading...
Need help?
General