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