Data Manipulation Language Statements › Logical Record Clauses

Logical Record Clauses

Logical record clauses are used with any of the four DML statements that access logical records: @OBTAIN, @MODIFY, @STORE, and @ERASE. The logical record clauses are as follows:

• WHERE specifies criteria used to select logical-record occurrences or 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 WHERE and ON clauses are explained in this section.