Parameters Used for Imports in Both the Header and Process Sections

The following information describes the parameters that can appear in either the header section or a process section, and are specific to an import process. For generic parameters that can be used in all EIM processes, see Process Section Parameters Generic to All EIM Processes. (The information in Process Section Parameters Used for Imports lists the parameters specific to an import process that appear in only the process section of the EIM configuration file.)

Parameter	Description
ATTACHMENT DIRECTORY	(Default = SIEBEL_HOME\INPUT) Specifies the directory to be used for importing attachments. Before specifying a directory, make sure the directory exists on a Siebel Server machine and you have read and write access to the directory. Example: ATTACHMENT DIRECTORY = SIEBEL_HOME\INPUT
COMMIT EACH PASS	Specifies whether a separate transaction should be used for each EIM pass through each EIM table. The default value is TRUE, which invokes commits after each pass. This setting helps to reduce the database resources required for the import process and provides a checkpoint to which you can return in the event of unexpected results. Note: COMMIT EACH PASS works cumulatively with COMMIT EACH TABLE. If you set both commit each pass and commit each Table to true, a commit will occur at the end of each pass and at the end of each table.
COMMIT EACH TABLE	Specifies whether a separate transaction should be used for each EIM table. The default value is TRUE, which invokes commits after each table. This setting helps to reduce the database resources required for the import process. Note: COMMIT EACH TABLE works cumulatively with COMMIT EACH PASS. If you set both commit each pass and commit each Table to true, a commit will occur at the end of each pass and at the end of each table.
COMMIT OPERATIONS	(Import only.) Specifies the number of insert and update operations to be performed before a commit is invoked. The value for this parameter, an integer greater than zero, prevents the transaction rollback space from overflowing when large data sets are imported. The default for COMMIT OPERATIONS is not set; a commit is thus invoked only at the end of the import by default. This setting is ignored if you have turned off Enable Transaction Logging. Note: This parameter is useful only for row-by-row processing (with transaction logging on). It is not used for set-based processing operations.
DEFAULT COLUMN	(Import only) Specifies a default value for an EIM table column. The syntax is column name, value. Example: DEFAULT COLUMN = CURCY_CD , "USD" The given value will be used only if the column is null in the EIM table.
FIXED COLUMN	(Import only.) Specifies the value for an EIM table column. The syntax is the same as for DEFAULT COLUMN. Example: FIXED COLUMN=ORG_CD, “Commercial” The given value will be loaded into the Siebel base table, overriding the value in the EIM table column.
INSERT ROWS	Specifies that nonexistent rows in the EIM table be inserted into the Siebel base table. The default value is TRUE. A table name can be specified with insert rows as the first value, separated by a comma. Example: INSERT ROWS = EIM_ACCOUNT, FALSE If the named table is an EIM table, as in the example, the setting applies to all Siebel base tables imported from this EIM table. If the named table is a Siebel base table, the setting is applied when data is imported from any EIM table. Note: The INSERT ROWS parameter must be set to FALSE for any table with an EIM table that does not have mappings to all its required columns, such as S_ORDER for EIM_ORDER_DTL. In this example, when EIM is not able to resolve the EIM_ORDER_DTL row to an existing S_ORDER record, it attempts to insert it as a new S_ORDER record. Since EIM_ORDER_DTL does not have mappings to all the S_ORDER required columns, the process fails with a “Cannot insert null” error. For more information on the INSERT ROWS parameter, see INSERT ROWS and UPDATE ROWS Parameters.
MISC SQL	Sets specific explicit or implicit primaries, as mentioned in Step 11 in EIM Import Process of the import process. Explicit is when you have specific values to set as primaries. Implicit is when any of a group of values is acceptable. For example, you are importing one account with nine addresses. If any of the addresses is acceptable as being the primary, then set primary to implicit. EIM then selects one of the addresses as primary. If a specific address should be the primary, then set primary to explicit and indicate the primary account by setting its flag column (EIM_ACCOUNT.ACC_PR_ADDR) to Y. Note: MISC SQL is intended for initial data loading only (with DOCKING TRANSACTIONS = FALSE), because when using MISC SQL to set primary child foreign keys, NO transactions are logged for mobile users. For a list of fields that can be set using the MISC SQL parameter, see MISC SQL Parameter.
NET CHANGE	(Import only.) Specifies the handling of null (non-user key) column values when importing a row that already exists in the Siebel database table. If NET CHANGE = TRUE, the null value will be ignored; otherwise, the column in the base table will be updated with NULL. This parameter is ignored if UPDATE ROWS = FALSE. The default value is TRUE; null attribute values will thus be ignored for existing rows by default. For more information on this parameter, see NET CHANGE Parameter.
ROLLBACK ON ERROR	Specifies whether the current transaction should be rolled back (aborted) when an error, such as an SQL database failure, is encountered. The default value is FALSE. If you set this parameter to TRUE, you should also set COMMIT EACH PASS and COMMIT EACH TABLE to FALSE, and make sure that the database transaction space is large.
TRIM SPACES	(Import only.) Specifies whether the character columns in the EIM tables should have trailing spaces removed before importing. The default value is TRUE.