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:

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.


 Siebel Enterprise Integration Manager Administration Guide 
 Published: 05 January 2004