Call SAP for Each Row in Recordset

When the Build single row at a time option is checked in the SELECT SQL window from Home Tab > Data Filter Builder, Process Runner DB makes a call to SAP for each record in record set instead of sending all the records to where clause for SAP in a single call.

To use Build single row at a time,

1. Enter the select statement and select Build single row at a time checkbox.
2. Select OK.

   

3. Consider that record set of select statement contain 100 records which are mapped in the where condition as follow.

   

4. Execute the process file. For each record in the select statement record set a call to SAP with above where condition is made and records are retrieved from SAP.