Change Current Record Position


Moves the position of the current record in the dataset.

Parameters

  • 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.

Notes:

  • 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".