Auto Get Next Row Operation
If input record fields belong to the same query, you can specify that the translator automatically performs a Move Next cursor operation as the input record loops.
In the Looping tab of the SQL Input Record Properties dialog box, select Automatically get next row from Statement record.
When to Use
The Automatically get next row from Statement record option must be used (selected) in the following scenarios:
- When retrieving all the data from one table and all the rows must be processed as one document
- When processing a repeating Detail record and all
corresponding Detail rows must be processed in order
Note: You must also use Key Fields in this scenario. When the key fields no longer match, the Automatically get next row from statement record function is not performed.
When mapping SQL with the Sterling B2B Integrator Map Editor, you must use automatically get next row when you want to move to the next row of the result set. If you do not instruct the translator to get the next row, it will never do so when running the map. Most often this function is used on a repeating record, when you want to map data from multiple rows of the result set, one row right after another.