DELETE Statement

When in UNIVERSE mode (set with the $OPTIONS statement), the DELETE statement will accept the following syntax variants.

Syntax

DELETE {file-var,}item-id {SETTING setting-var} {ON ERROR statement(s)} {LOCKED statement(s)}

or

DELETE {file-var,}item-id {SETTING setting-var} {LOCKED statement(s)} [THEN statement(s) | ELSE statement(s)]}

Comments

• You cannot use both ON ERROR and THEN/ELSE.

• The ELSE clause has the same function as ON ERROR.

• The LOCKED clause is supported only to simplify migration to Reality. The associated statements will never be executed.