Bookshelf Home | Contents | Index | PDF |
Siebel Enterprise Integration Manager Administration Guide > Exporting Data > Editing the Configuration File for Export Processing > Parameters Used for Exports in Both the Header and Process SectionsTable 14 describes the parameters that can appear in either the header section or a process section, and are specific to an export process. For generic parameters that can be used in all EIM processes, see Process Section Parameters Generic to All EIM Processes.
EXPORT MATCHES ParameterThe 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 To check whether a base table is of Siebel extension type. 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...)" below) 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 TableThe syntax listed below 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_PARTYThe syntax listed below 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 Check the Type property value. If the Type property value contains 'Extension (Siebel),' then the table is a Siebel extension type table. |
Siebel Enterprise Integration Manager Administration Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |