Change Current Record Position
Moves the position of the current record in the dataset.
Dataset name Specifies the name for the dataset. The dataset must be opened before.
Move position of current record to Specifies how to move the position of the current record. It can be one of the following:
- Moves to the first record
- Moves to the previous record
- Moves to the next record
- Moves to the last record
- Moves to backward or forward x records
Current record position moves to x steps Specifies the number of records that the current record position moves.
Return EOF/BOF state into variable Specifies the name of the variable that will be populated with the EOF or BOF state.
Do not log execution message Specifies whether to log the execution message. With the option checked, it may avoid redundant log information in some situation.
The EOF and BOF state will be stored into the specified variable in the number format. 1 is EOF or BOF, 0 is not.
For more information about the dataset, please refer to "Execute SQL Statement" or "Connect dataset in parent task".