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 = "********"
    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