1) Select/Fetch
2) Reselect
3) Restart able
Select/Fetch: -
Opens the cursor only
at the first time and retrieve rows one at loop.
Commits inside the
step (commits in the Called Section) are ignored if AE is Restart enabled.
Reselect: -
It opens the cursor and closes the cursor on each iteration
of the loop.
It will reselect the same row of data.
Logic in Actions of the step should be such that it will be
changing the status of the rows in the table the do select is selecting.
Commits are not ignored and will be committed in a reselect
loop when the restart is enabled.
Restart able: - similar to select/Fetch but it WILL COMMIT
inside the loop thus allowing the checkpoint to the PS_AERUNCONTROL table.
