Example: Using DELETE MATCHES to Delete Data from non-S_PARTY Extension Tables

If the EIM table’s target table is not S_PARTY:

DELETE MATCHES = [EIM table name], [...criteria...]
DELETE MATCHES = [target base table name], [...criteria...]
DELETE MATCHES = [...criteria...

For example, if you want to delete all activities created by employee SADMIN, you go to the S_EVT_ACT table and find all the records with the following:

	OWNER_LOGIN='SADMIN'

You can use the following session in your .IFB file:

	[Delete Activity]
	TYPE = DELETE 
	BATCH = 100
	TABLE = EIM_ACTIVITY
	DELETE MATCHES = <Table>, (OWNER_LOGIN = 'SADMIN')

<Table> can be replaced by EIM_ACTIVITY or S_EVT_ACT, or it can be remain empty.