Data Manipulation Language Statements › Logical-Record Clauses (WHERE and ON)

Logical-Record Clauses (WHERE and ON)

Logical-record clauses are used with any of the four DML statements that access logical records (that is, OBTAIN, MODIFY, STORE, or ERASE). The logical-record clauses are as follows:

• WHERE—Specifies criteria used to select and/or criteria used to limit the selection of logical-record occurrences.
• ON—Tests for a specific path status returned to indicate the result of a logical-record DML statement.

The following subsections describe the WHERE and ON clauses.