Delete Specification and Soft Delete

This specification defines the driven dataset and matching key for deleting the target table.

Syntax:

delete_specification ::= [soft_delete_spec ] deletesource_specification
soft_delete_spec ::= DELETETYPE '[' SOFT [create_soft_delete_column] ']';
create_soft_delete_column ::= column_name
deletesource_specification ::= DELETESOURCE table_name  column_list MATCHING column_list;

Example:

IMPORT SOURCE CUSTOMER_DELETE_LOG 
IMPORT SOURCE CUSTOMERS
DEFINE DATASET CUSTOMERS_D 
   ROWSOURCE CUSTOMER_HD; 
   THIS = CUSTOMER_HD;

   DELETESOURCE CUSTOMER_DELETE_LOG[CUST_ID] MATCHING [CUST_ID]; 
END 

You've defined the dataset CUSTOMER_DELETE_LOG to identify and delete the matched records in the dataset CUSTOMERS_D.