How should EXPORT MATCHES and DELETE MATCHES be used in Siebel?

The syntax of EXPORT MATCHES and DELETE MATCHES has been changed in version 7.x./8.x This information was not available in the Siebel Bookshelf.

The following are the correct syntax for the EXPORT MATCHES and DELETE MATCHES parameters:

If the interface table's target table is not S_PARTY:

- It allows syntax of:

EXPORT MATCHES = <interface table name>, (...criteria...)
or
DELETE MATCHES = <interface table name>, (...criteria...)

EXPORT MATCHES = <target base table name>, (...criteria...)
or
DELETE MATCHES = <target base table name>, (...criteria...)

EXPORT MATCHES = (...criteria...)
or
DELETE MATCHES = (...criteria...)

- It does not allow syntax of:

EXPORT MATCHES = <non-target base table name>, (...criteria...)
or
DELETE MATCHES = <non-target base table name>, (...criteria...)

If the interface table's target table is S_PARTY:

- It allows syntax of:

EXPORT MATCHES = <target base table name, i.e. S_PARTY>, (...criteria...)
or
DELETE MATCHES = <target base table name, i.e. S_PARTY>, (...criteria...)

EXPORT MATCHES = <non-target base tables name of Siebel Extension type>, (...criteria...)
or
DELETE MATCHES = <non-target base tables name of Siebel Extension type>, (...criteria...)

- It does not allow syntax of:

EXPORT MATCHES = <interface table name>, (...criteria...)
or
DELETE MATCHES = <interface table name>, (...criteria...)

EXPORT MATCHES = (...criteria...)
or
DELETE MATCHES = (...criteria...)

To check whether a base table is of Siebel Extension type, do the following:

Login to Tools

Navigate to Table control and query a table name.

Check the Type property value. If it contains 'Extension (Siebel)', it means that this table is a Siebel Extension type table.

Note: The column names included in the criteria must be columns from the target base table or table that is specified for the EXPORT MATCHES parameter.

Strong caution is recommended when using DELETE MATCHES against non-target base table of Siebel Extension type (for example, S_ORG_EXT and S_CONTACT):

S_ORG_EXT contains records for accounts, divisions, organizations and partners.

To delete all accounts, but not divisions, organizations or partners, use the following .ifb setting:
DELETE MATCHES = S_ORG_EXT, (INT_ORG_FLG = 'N' AND PRTNR_FLG = 'N')

Refer to following SupportWeb posting on similar behavior:
Service Request 38-680047351: Using EIM to delete all Accounts
(The posting can be found by searching SupportWeb using search string: EIM AND DELETE AND EIM_ACCOUNT AND S_PARTY)

To delete all rows from S_ORG_EXT (including accounts, divisions and organizations), please use the following .ifb setting:

DELETE MATCHES = S_ORG_EXT, (NAME <> 'Default Organization')
(The seed data 'Default Organization' should not be deleted.)

S_CONTACT contains records for contacts and employees.

To delete all contacts, but not employees, use the following .ifb setting:
DELETE MATCHES = S_ORG_EXT, (EMP_FLG = 'N')

To delete all rows from S_CONTACT (including contacts and employees), use the following .ifb setting:

DELETE MATCHES = S_ORG_EXT, (ROW_ID <> '0-1')
(S_CONTACT record with ROW_ID = '0-1' is the seed data for Siebel Administrator, which should not be deleted.)