Building the Action Diagram › How to Define Logic for Elementary Processes and Procedures › Add Assignment Actions › DATABASE EXCEPTION Statement › Add Database Exception Logic to an Entity Action Statement

Add Database Exception Logic to an Entity Action Statement

You can add database exception logic to the following entity action statements:

• READ
• READ EACH
• SUMMARIZE
• SUMMARIZE EACH
• CREATE
• UPDATE
• DELETE
• ASSOCIATE (standalone form)
• TRANSFER (standalone form)
• DISASSOCIATE (standalone form)

To add database exception logic to an entity action statement

1. Click Analysis or Design, Action Diagram.

   The Action Diagram Names dialog appears.

2. Select a process from the Processes list.
3. Select an action block from the Action Blocks list and click OK.

   The entity action statements are displayed in the Action Diagram window.

4. Right-click the last statement in the entity action statement and click Edit, Add Statement, Database Exception.

   The database exception statements are added automatically after each statement.

   Note: You can also select the statement itself for READ EACH and SUMMARIZE EACH statements. Database Exception logic displays after any other statements that are enclosed by, and subordinate to, the READ EACH or SUMMARIZE EACH. A new "(for each successful iteration)" line also displays immediately before any such subordinate statements. Contract the line "(for each successful iteration)" to display database exceptions next to a READ EACH or SUMMARIZE EACH statement.

5. Type the exception logic you need to add after each WHEN clause.