The FIND statement locates a specific record in the database and
establishes it as the current record of the run unit.
Format 1 -
FIND database-record [ FOR UPDATE ]
[ [{| REALM |}] ]
[RETAINING [{| RECORD |}] CURRENCY]
[ [{| { SET [ set-name ] ... } |}] ]
[ [{| { { set-name } ... } |}] ]
[{ [ AT END stment ] [ NOT AT END stment ] } ]
[{ [ ON ERROR stment ] [ NOT ON ERROR stment ] } ]
[ END-FIND ]
1 – database-record
represents a record selection expression. References are made to a record in the database according to the rules for Record Selection Expressions.
2 – set-name
names a subschema set type.
3 – stment
is an imperative statement.