Siebel Enterprise Integration Manager Administration Guide > EIM: Examples of Common Usage > EIM Delete Process Examples >

Example of Deleting Specific Positions from Accounts

To delete specific positions from an account, you must populate the interface table EIM_ACCOUNT with an SQL script in addition to making modifications to the .IFB file. This is because DELETE MATCHES does not work for nonbase tables.

You can use the following sample .IFB file:

[Siebel Interface Manager]

USER NAME = "SADMIN"

PASSWORD = "SADMIN"

PROCESS = DELETE

[DELETE]

TYPE = SHELL

INCLUDE = "Delete Accounts Main"

[Delete Accounts Main]

TYPE = DELETE

BATCH = 1

TABLE = EIM_ACCOUNT

ONLY BASE TABLES = S_ACCNT_POSTN

DELETE EXACT = TRUE