Program Level
State Record
One of the state
record needs to SQL Table, Since All Derived work record will be
re-initializing on commit.
Program Properties
On the Advanced
tab in the program properties dialog box, make sure that disable restart is not
checked.
Configuration manager
In the
configuration manager, sure that Disable restart is not selected on the process
scheduler tab.
Section Level
Section type
The option for
section type are prepare only and critical updates
n If the
section is preparing data i,e select data, Populating temporary tables, or
updating temporary tables then the section should be prepare only.
n If the
section is updating the permanent application tables in the database, you
should select critical update.
Step Level
Add an order by clause
%Select Field Select Field1
from PS_SOME_RECORD Where FIELD1 >
%Bind (FIELD1) Order by FIELD1.
Add a switch to the selected table
Delete processed rows.
The only
restriction for batch runs occurs when you have restart enabled, and you are
inside a Do Select that is of the Select/Fetch type (instead of
"Re-select" or "Restartable"). with select/Fetch, all
commits inside the loop are ignored, including the commit frequency if it's
set.
