Siebel Enterprise Integration Manager Administration Guide > EIM: Examples of Common Usage > EIM Delete Process Examples >

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 left empty.