Bookshelf Home | Contents | Index | Search | 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 Sections
Table 13 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.
Table 13. Export Process Parameters for the EIM Configuration File - Header and Process Sections Specifies that all rows in the target base table and secondary tables are to be exported. The default value is FALSE. Existing values in the EIM table and export matches expressions are ignored. For all columns to export using an EIM table (both data from the base table and data from related child tables), you need to make sure this parameter is set to TRUE (you may need to add this line if it does not currently exist) in the .IFB file. For more information on the EXPORT MATCHES parameter, see EXPORT MATCHES Parameter.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 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.
Syntax for EXPORT MATCHES with S_PARTY as the Target Base Table
The 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_PARTY
The 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...)
NOTE: The column names included in the criteria must be columns from the target base table or the table that is specified for the EXPORT MATCHES parameter.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Enterprise Integration Manager Administration Guide Published: 05 January 2004 |