Looping Tab
The following list describes the properties on the Looping tab for the SQL Input and Output Record dialog boxes:
- Min Usage
- Minimum
amount of times the loop must repeat.
If the Min Usage box contains 0 (zero), the record is conditional. If the Min Usage box contains 1 or greater, the record is required.
- Max Usage
- Maximum amount of times the loop can repeat.
- Normal
Loop Start
Loop End - Type of loop. Select Normal. This record is in the loop but is not the beginning or ending record. Loop Start and Loop End are used for EDI.
- Automatically get next row from Statement record
- If selected, the translator performs a movement operation as the input record loops. This property is deactivated on SQL Output Records.