Bookshelf Home | Contents | Index | Search | PDF |
Siebel Enterprise Integration Manager Administration Guide > Common EIM Usage Examples > 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:
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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Enterprise Integration Manager Administration Guide Published: 05 January 2004 |