IFB Parameters for EIM

The parameters used in an IFB are classified as follows:

• General Header Parameters.
• General Process Parameters.
• Import Process Parameters.
• Export Process Parameters.
• Delete Process Parameters.
• Merge Process Parameters.

General Header Parameters

These are the global parameters which are used in an IFB file and are written with in the Header section in an IFB file. They are :-

• CONNECT
• LOG TRANSACTIONS TO FILE
• PASSWORD
• PROCESS
• [Siebel Interface Manager]
• TABLEOWNER
• USER NAME

To know more on general header parameters, click here . . .

General Process Parameters

These are the parameters which are common to all the EIM process (Import,Export,Delete,Merge) and are written with in the Process section in an IFB file. They are :-

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

To know more on general process parameters, click here . . .

Import Process Parameters

These are those parameters which are only applicable to EIM Import process and are written with in the Process section in an IFB file used for import process. They are :-

• COMMIT OPERATIONS
• FILTER QUERY
• IGNORE BASE COLUMNS
• ONLY BASE COLUMNS
• UPDATE ROWS
• ATTACHMENT DIRECTORY
• DEFAULT COLUMN
• FIXED COLUMN
• INSERT ROWS
• MISC SQL
• NET CHANGE
• TRIM SPACES

To know more on import process parameters, click here . . .

Export Process Parameters

These are those parameters which are only applicable to EIM Export process and are written with in the Process section in an IFB file used for export process. They are :-

• ATTACHMENT DIRECTORY
• CLEAR INTERFACE TABLE
• EXPORT ALL ROWS
• EXPORT MATCHES

To know more on export process parameters, click here . . .

Delete Process Parameters

These are those parameters which are only applicable to EIM Delete process and are written with in the Process section in an IFB file used for delete process. They are :-

• CASCADE DELETE ONLY
• CLEAR INTERFACE TABLE
• DELETE ALL ROWS
• DELETE EXACT
• DELETE SKIP PRIMARY
• DELETE MATCHES
• DELETE ROWS
• UPDATE ROWS

To know more on delete process parameters, click here . . .

Merge Process Parameters

These are those parameters which are only applicable to EIM Merge process and are written with in the Process section in an IFB file used for merge process. They are :-

• SET BASED LOGGING
• UPDATE ROWS

To know more on merge process parameters, click here . . .