Technical data

General Formats

Format 1—Database Key Identiﬁer Access

This format selects a record by a database key value held by the Database Control

System (DBCS) in a currency indicator or a keeplist entry.

database-key-identiﬁer

identiﬁes a record according to the rules of database key identiﬁers. (See

Section 4.4, Database Key Identiﬁers for more information.)

For example:

FIND CURRENT WITHIN PART-REC

Format 2—Set Owner Access

This format selects the record that owns a set.

OWNER

WITHIN set-name

set-name

is a subschema set name. The DBCS uses the currency indicator for set-name to

choose the owner record of that set occurrence. A database exception condition

occurs if set-name is a singular set (DB-CONDITION is set to DBM$_SINGTYP)

or if the currency indicator for the set type is null (DB-CONDITION is set to

DBM$_CSTYP_NULL).

Format 3—DB Key Access

This format selects the record that is referred to by the database key contained in

the special register DB-KEY.

DBKEY

Format 4—Record Position Access

This format selects a record by its position within a collection of records and

optionally by its record type and contents.

FIRST

LAST

PRIOR

ANY

DUPLICATE

RELATIVE

int-exp

record-name

WITHIN

realm-name

set-name

USING

rec-key

...

WHERE

bool-expression

bool-expression:

4–10 Procedure Division