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 S_PARTY Extension TablesIf 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. |
Siebel Enterprise Integration Manager Administration Guide |