Actions are RDBMS commands, such as COMMIT WORK, that the data adapter issues in response to events in a FOCUS session. Events include the end of a MODIFY or TABLE request, interaction with the terminal, and the end of a FOCUS session. |
How to: Automatically Invoke Actions in Response to Events Reference: |
For DB2, you can make a MODIFY transaction pseudo-conversational by issuing CLOSE and DISCONNECT automatically at all COMMIT points within the MODIFY procedure. Or, by delaying COMMITs until a group of commands is issued, you can combine FOCUS commands and native SQL commands in one Logical Unit of Work.
The SET AUTOaction command allows you to control when the data adapter issues actions. Subsequent sections discuss each action.
SQL [sqlengine] SET action ON event
where:
Note:
Information Builders |