Previous Topic: Add a Retry Transaction Action StatementNext Topic: Inline Code Statement


REMOVE Statement

The REMOVE statement is part of the UPDATE construct. You can use the REMOVE statement to remove attribute values; however, code generation does not support the REMOVE statement. Use ASSOCIATE, DISASSOCIATE, or TRANSFER to change relationships. Mandatory attributes may not be the subject of a REMOVE clause.

In the following example, the UPDATE action signals modification to the information stored about the PERSON entity in the entity action view PERSON. The SET clause changes the stored name of the PERSON to "John."

UPDATE person 
SET name TO "John" 
REMOVE address 
TRANSFER FROM original order WHICH is placed by IT 
TO new order WHICH is placed by IT 

The REMOVE statement eliminates the stored address of the person. The TRANSFER clause replaces the original pairing between the previous PERSON (for whom we do not have a name) and ORDER by a pairing between the former PERSON name (now John) and his new ORDER.