Building the Action Diagram › How to Define Logic for Elementary Processes and Procedures › Add Repeating Actions › Add READ EACH Entity Action › Detail Properties of a READ EACH Statement

Detail Properties of a READ EACH Statement

You can specify whether a DISTINCT clause is generated in a READ EACH statement using the READ EACH Properties dialog. The dialog also allows you to specify whether an OPTIMIZE FOR clause is generated for DB2 applications.

Note: For more information, see the Toolset Help.

To access the dialog and Toolset Help, select the READ EACH statement. With the statement highlighted, select the Detail pull-down menu and the Properties action.

To select this option, display the READ EACH properties dialog by either double clicking on the READ EACH statement or by selecting the READ EACH statement and then selecting Detail—>Properties from the menu bar. On the properties dialog, click the "Generate with cursor hold" check box.

This option is valid only for DB2. This option is ignored for all other DBMSs.