Previous Topic: @ERASE (LRF) SyntaxNext Topic: @ERASE (LRF) Status Codes


@ERASE (LRF) Parameters

REC=logical-record-name

Deletes the named logical record. Unless the IOAREA clause (below) is included, LRF uses field values present in the variable-storage location reserved for the logical record to make any necessary updates to the database. Logical-record-name must specify a logical record defined in the subschema.

IOAREA=alt-logical-record-location

Identifies an alternative variable-storage location from which LRF is to obtain field values to perform the appropriate database updates in response to this statement. When erasing a logical record that has previously been retrieved into an alternative storage location, you should use the IOAREA parameter to name the same location specified in the @OBTAIN request. If the IOAREA parameter is included in the @ERASE statement, alt-logical-record-location must identify a record location defined in the program.

ONLRSTS=path-status,GOTO=branch-location

Tests for the indicated path status. If path-status results from this @ERASE statement, the action specified by GOTO=branch-location is performed. Path-status must be a literal (1-16 bytes) enclosed in quotation marks or a program variable.

WHERE boolean-expression

Specifies the selection criteria to be applied to the specified logical record.

Note: For more information about the WHERE clause, see WHERE Clause later in this chapter.