ApplicationEngine Action

A few things about Actions.





1. There is a specific order in with Actions get executed. The order in which you create them does not matter.



1. DO when ( like a if statement.) If the sql returns 1 or more rows, subsequent actions are executed just once.

2. Do While ( Loop. Will exceute all subsequent actions once for every row returned by query.

3. Do SELECT ( Like a for loop. Will execute once for every row returned. )

4. Peoplecode

5. Call Section:

6. SQL

7. Log Message

8. Do Until: Will execute subsequent actions till no rows are returned by the query. Will executed at least one. If if no rows returned the first time, it will executed actions at least one time.



2. Only one SQL action can exist in a Step.

3. SQL Action and Call section are mutually exclusive in a step.