Application Engine: The different types of Do Select
Select/Fetch – Opens the cursor only once and retrieves rows one at a time. Commits inside the step (commits in the Called Section) are ignored if the program is restartable (noticeable in the trace file) and are not ignored if the program is not restartable. Reselect – Opens the cursor and closes the cursor on each iteration of the loop. It will re-select the same row of data. Logic in Actions of this step should be…