Export All Rows IFB File

Here, Let's look at the IFB file which can be used to export entire records from a Siebel base table. For that, you have to just include the parameter 'EXPORT ALL ROWS' in the IFB file and its value should be set to true. 
Here is the IFB file to be 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,S_CASE_REL
EXPORT ALL ROWS = TRUE

If we want to export from more than one base table associated to an interface table, we can specify all base tables with in 'ONLY BASE TABLES'  parameter in IFB. If there is a need to export all records 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 MATCHES' parameter, click here . . .