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 S_PARTY Extension Tables
If the EIM table's target table is S_PARTY:
DELETE MATCHES = S_PARTY, [...criteria...]
DELETE MATCHES = [non-target base tables name of Siebel Extension type], [...criteria...]
In this example, you want to delete an existing account. This account's data is as follows:
S_PARTY: PARTY_TYPE_CD='Organization', PARTY_UID='1-28XIF'
S_ORG_EXT: LOC='San Mateo', NAME='TEST', BU_ID=' 0-R9NH"
If you would like to apply criteria against the S_PARTY table, you can use the following session in the .IFB file:
DELETE MATCHES = S_PARTY, (PARTY_UID = '1-28XIF')
Or if you would like to apply criteria against the S_ORG_EXT table, you can use the following session in the .IFB file:
DELETE MATCHES = S_ORG_EXT, (NAME = 'TEST')
Both methods achieve the same result. But in this example, it is easier to use criteria against S_ORG_EXT, since you know which account you want to delete.
NOTE: When S_PARTY is the target base table, you cannot use the EIM table name or neglect the target base table name in DELETE MATCHES expressions.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Enterprise Integration Manager Administration Guide Published: 05 January 2004 |