EXPORT MATCHES Parameter

The EXPORT MATCHES parameter specifies a where clause expression for filtering base table rows. The value is in two parts: the Siebel EIM table name and the filter expression that goes against the target base table. The expression is applied against the target base table for the EIM table.

The expression is a self-contained where clause expression (without the where) and should use only literal values or unqualified column names from the base table. There must also be a space separating the operator from the operand.

Note: Complex SQL WHERE clauses like subqueries are not supported.

EXPORT MATCHES can be used only against a target base table, or against a non-target base table that is an extension table of S_PARTY when the target table is S_PARTY. For more information, see the following.

The syntax to use with the EXPORT MATCHES parameter depends on whether the target base table is S_PARTY or not.

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

Syntax for EXPORT MATCHES with S_PARTY as the Target Base Table

The syntax shown in this topic is for use with the EXPORT MATCHES parameter if the EIM table’s target table is S_PARTY. Allowed syntax includes the following:

EXPORT MATCHES = S_PARTY, (...criteria...)
EXPORT MATCHES = <non-target base table name of Siebel Extension type>,
(...criteria...)

Note: When using the EXPORT MATCHES parameter against a non-target base table, you must still include the target table in the export.

The following syntax is not allowed:

EXPORT MATCHES = <EIM table name>, (...criteria...)
EXPORT MATCHES = (...criteria...)

Syntax for EXPORT MATCHES with Target Base Tables Other Than S_PARTY

The syntax shown here is for use with the EXPORT MATCHES parameter if the EIM table’s target table is not S_PARTY. Allowed syntax includes the following:

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

The following syntax is not allowed:

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

To check whether a base table is of Siebel extension type

In Siebel Tools, navigate to the Table control and query a table name.

Check the Type property value. If the Type property value contains ‘Extension (Siebel),’ then the table is a Siebel extension type table.