Siebel Enterprise Integration Manager Administration Guide > EIM Configuration File > Defining EIM Configuration File Parameters >

Setting EIM Configuration Parameters

Table 6 lists the general configuration parameters that can be set when using EIM.

Keep in mind the following points when working with the EIM configuration file:

• Lines in the default.ifb file that begin with a semicolon (;) are comment lines and are ignored.
• If you are continuing a parameter definition to multiple lines in the .IFB file, make certain that the backslash character (\) is the last character on the line. The backslash character denotes continuation. Do not combine comments (;) with new lines (/) because this format creates difficulties finding a comment in the middle of a line.

  CAUTION:  When the backslash is followed by a space, EIM interprets the space character as "escaped," and the new line character then terminates the parameter definition. This can generate an error message indicating the parameter definition is incomplete.

  If multiple lines have the backslash (continuation) character (\) at the end, this means they are a single parameter line. So, if a semi-colon (comment character) is placed among these lines, EIM ignores the column with the semi-colon.

  For example:

  ONLY BASE COLUMNS = S_PARTY.PARTY_TYPE_CD,\

  S_PARTY.PARTY_UID,\

  ; S_PARTY.ROOT_PARTY_FLG,\

  S_CONTACT_FNX.PAR_ROW_ID,\

  S_CONTACT_FNX.X_BATCH_ID

  These statements will cause EIM to comment off S_PARTY.ROOT_PARTY_FLG.

• PASSWORD and USERNAME values are generally not used for access authentication or as a security measure. EIM acquires access authentication from the component parameters.

  PASSWORD and USERNAME values in the .IFB file are only used if the parameters are not set at the enterprise or component level.

Setting EIM Configuration File Header Parameters

The first nonblank, noncomment line of the configuration file's header section must contain the exact information shown:

[Siebel Interface Manager]

Table 6 lists the other general header parameters to set when using EIM.

Setting EIM Configuration File Process Parameters

This topic describes only the general process parameters, that is, the process parameters that are generic to all EIM processes and that appear in the process section of the EIM configuration file. The process-specific section parameters are described in the chapters that cover each specific EIM process.

Table 7 lists the general process parameters to set when using EIM.

The first nonblank, noncomment line of each process section is a bracketed string that specifies the name of the process. This is the name used in the process argument, or in the run process parameter in the header section. The value between the square brackets ([and]) can contain alphanumeric characters, spaces, and the following punctuation marks:

# _ : - $ % / +

There are two types of keywords for process section parameters: required keywords and optional keywords.

Required Keywords for Process Parameters

Of the general configuration parameters listed in Table 7, note that the following ones are required when using EIM:

• TYPE
• BATCH
• TABLE

Optional Keywords for Process Parameters

Of the general configuration parameters listed in Table 7, note that the following ones are optional when using EIM:

• COMMIT EACH PASS
• COMMIT EACH TABLE
• IGNORE BASE TABLES
• INCLUDE
• LOG TRANSACTIONS
• ONLY BASE TABLES
• ROLLBACK ON ERROR
• SKIP BU_ID DEFAULT
• SESSION SQL
• TRANSACTION SQL
• UPDATE STATISTICS
• USE ESSENTIAL INDEX HINTS
• USE INDEX HINTS
• USING SYNONYMS

TRANSACTION SQL Parameter

This parameter specifies a user-defined SQL statement to be sent to the database before other SQL statements and immediately after each commit or rollback operation during the process (including subprocesses). Although a commit operation is processed first, this statement is emitted (for the first time) immediately after the session sql parameter. Only one TRANSACTION SQL parameter can be used in each process section.

You must define the rollback of the EIM process by doing either of the following:

• Add the TRANSACTION SQL parameter in the configuration file.
• Use the Server Manager to set the Database Rollback Segment Name parameter of the Enterprise Integration Mgr component at the component level.

  To avoid errors, do not specify the rollback segment:

• When using the siebenv.bat file.
• At the task level.
• When using both the configuration file and the Server Manager.

  NOTE:  Do not use the TRANSACTION SQL parameter to insert or update data in Siebel base tables.

To define the rollback segment in the configuration file

• Add a line (as shown in the following example for an Oracle database) to the EIM configuration file.

  TRANSACTION SQL = "set transaction use rollback segment rb_big"

To define the rollback segment using the Server Manager

1. Navigate to Administration - Server Configuration > Servers > Components > Parameters.
2. In the Components list, select Enterprise Integration Mgr.
3. Click the Component Parameters view tab.
4. In the Component Parameters list, select Database Rollback Segment Name.
5. In the Current Value field, type the name of the rollback segment to be used and click Save.

For more information on using the Server Manager, see Siebel System Administration Guide.