Setting Up Step Properties

You set up step properties in Definition view.

Field or Control	Description
Step Name	Enter a name (up to eight characters).
Commit	Specify the commit level for the step: Default: Select to inherit whatever commit level you specified for the section in which the step resides. Later: Select to postpone the commit until a subsequent commit occurs. Here you can override the section-level commit if it is set to After Step. After Step: Select if you have a commit level of None specified at the section level. This selection enables you to override the section-level commit and commit a specific step within a section with no other commits.
Frequency	Enabled only when a step contains one of the following actions: Do While, Do Select, or Do Until. Enter the numeric frequency with which Application Engine should commit. If non-zero, Application Engine commits every N iterations and then again after the last iteration.
On Error	Specify how Application Engine should respond to an error at the step level. The On Error routine behaves the same for both SQL and PeopleCode actions. The program only terminates on errors, not warnings. Select from: Abort: The application terminates with an error message. Ignore: The program continues but logs an error message. Suppress: The program continues and presents no error message. SQL: Usually a program terminates if a SQL Prepare statement or execute fails. If you select Ignore or Suppress, errors on running programs are suppressed, but errors on compiles still cause the program to terminate. Thus, if you select to reuse an Update statement, the program fails on the compile if the SQL is incorrect, but it does not fail on a duplicate key error or similar error when the program runs. PeopleCode: The program has a PeopleCode error if the return code satisfies the statement`If (nRet & PCM_ERROR)`.
Status	Select to activate a step. If the step is currently applicable to your program (and working), you will probably want to keep it active.

Note:

The On Error property does not apply to compile errors (for example, specifying erroneous SQL statements). It checks only for execution-type errors. If your program has a syntax error, the program terminates.