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 Tables

If the EIM table's target table is S_PARTY:

The syntax is as follows:

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 Account]

TYPE = DELETE

BATCH = 100

TABLE = EIM_ACCOUNT

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 Account]

TYPE = DELETE

BATCH = 100

TABLE = EIM_ACCOUNT

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.