Bookshelf Home | Contents | Index | PDF |
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 TablesIf 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: You can use the following session in your .IFB file: DELETE MATCHES = <Table>, (OWNER_LOGIN = 'SADMIN') <Table> can be replaced by EIM_ACTIVITY or S_EVT_ACT, or it can be left empty. |
Siebel Enterprise Integration Manager Administration Guide |