Tuesday, September 18, 2012

Export Matches IFB File

Here, Let's look at the IFB file which can be used to export certain amount of records that matches a condition.If u need only some specific records to be exported from a Siebel database, you can make use of this.

The thing you have to do is, you have to specify the SQL statement to select the specific records needed with in the 'EXPORT MATCHES' parameter in the IFB.
Here is the IFB file used :-

[Siebel Interface Manager]
PROCESS = CASE_EXPORT
[CASE_EXPORT]
TYPE = SHELL
INCLUDE = "EXPORT_CASE"
[EXPORT_CASE]
TYPE = EXPORT
BATCH = 1
TABLE = EIM_CASE
EXPORT ALL ROWS = FALSE
CLEAR INTERFACE TABLE = TRUE
ONLY BASE TABLES = S_CASE,S_CASE_PER,S_CASE_ORG
EXPORT MATCHES = S_CASE_PER, (ROW_ID IN ('1-4749','1-2789'))

If there is a need to export from an inter table like S_CASE_PER, we should also mention base tables associated to that within 'ONLY BASE TABLES'  parameter as here and should filter tables other than the inter table using 'EXPORT MATCHES' parameter.

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

No comments:

Post a Comment