Previous Topic: DISASSOCIATE EntitiesNext Topic: Add Assignment Actions


TRANSFER Relationships

You can TRANSFER relationships defined as transferable in the Data Model. The TRANSFER action exchanges the relationship between specific entity occurrences. The effect of TRANSFER is to change the pairing from one entity to another. This action does not affect the relationship between the entities in the Data Model.

Identifying relationships may not be the subject of a TRANSFER clause. Also, the relationship membership cannot have a many-to-many cardinality.

You must READ or CREATE the entity before you TRANSFER the relationship. You can TRANSFER as part of an UPDATE or as a standalone action. If you TRANSFER a relationship between entities where the relationship is mutually exclusive, the application terminates.

To illustrate TRANSFER relationships, consider multiple warehouses, each of which holds products. Products can be moved between warehouses. In the following statement, PRODUCT has been moved from PROCESSING WAREHOUSE to NEW WAREHOUSE:

TRANSFER received product
FROM processing warehouse WHICH holds it
TO new warehouse WHICH holds it

The relationship between WAREHOUSE and PRODUCT is represented in the Data Model as PRODUCT always is held in one WAREHOUSE and WAREHOUSE sometimes holds one or more PRODUCT. The relationship is defined as transferable and is not changed in the Data Model.