Other important information about working with trigger programs

 

Here are the recommendations, precautions, and error messages for trigger programs. Information about monitoring and commitment control is also included.

• Recommendations for trigger programs
  Consider these recommendations when you create a trigger program.

• Precautions to take when coding trigger programs
  Trigger programs can be very powerful. But take caution when coding trigger programs.

• Monitoring the use of trigger programs
  DB2 Universal Database™ for iSeries™ provides the capability to associate trigger programs with database files. Trigger-program capability is common across the industry for high-function database managers.

• Trigger and application programs that are under commitment control
  Here are the considerations for trigger and application programs that are running under commitment control.

• Trigger and application programs that are not under commitment control
  Here are the considerations for trigger and application programs that are not running under commitment control.

• Trigger program error messages
  If a failure occurs when the trigger program is running, the program must signal an appropriate escape message before exiting. Otherwise, the application assumes that the trigger program ran successfully.

 

Parent topic:

Creating trigger programs