Step properties:-

On Error: –

• Abort – Write message to message log and terminate.
• Ignore – Write message to message log and continue.
• Uppress – No message will be WRITTEN, but program will continue.

People code Action: –

• On RETURN options can used to handle run time errors.
• Abort: – Exits immediately – Not recommended.
• Break: – Exits the current step and section and control returns to the calling step.
• Skip Step: – The program exits the current step, and continues processing at the NEXT step in the section. If this is the LAST step in the section, the calling step resumes control of the processing.

SQL Action properties: –

• No Rows: – When the Sql doesn’t return any rows, you can tell what application engine program should do.
• Abort: -Program terminates Section Break: -Application Engine exits the current section immediately, and control returns to the calling step.
• Continue: – The program continues processing Skip Step: – Application Engine exits the current step immediately and MOVES on to the next step.
• When using skip step keep the following in mind:1) Application Engine ignores the commit for the current step at runtime2) If the current step contains only one Action, only use skip step at by-pass the commit.

Step properties:-

On Error: –

People code Action: –

SQL Action properties: –