The FIND ALL statement locates zero or more records in the database and inserts them into the named keeplist. Format 2 - FIND ALL keeplist-name [ record-name ] [ WITHIN { realm-name } ] [ { set-name } ] [ USING { rec-key } ... ] [ FOR UPDATE ] [ WHERE { bool-exp } ] [{ [ AT END stment ] [ NOT AT END stment ] } ] [{ [ ON ERROR stment ] [ NOT ON ERROR stment ] } ] [ END-FIND ]
1 – keeplist-name
names a keeplist in the Sub-Schema Section.
2 – record-name
is a subschema record name.
3 – realm-name
is a subschema realm name.
4 – set-name
is a subschema set name.
5 – rec-key
is a key data item within the subschema record occurrence. The same rec-key can appear only once in a given USING phrase.
6 – bool-exp
is a conditional expression that involves data items of the object record. It is used to specify additional requirements of a qualifying record.
7 – stment
is an imperative statement.