Kbase 19444: What are the differences between the AS/400 triggers and Progress triggers?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
What are the differences between the AS/400 triggers and Progress triggers?
FACT(s) (Environment):
Progress/400
FIX:
They are similar in the sense that both are code that executes in response to an action in the Database,
Types of triggers
Progress
Table Create, Delete, Find, Write
Fields Assign
DB2-400
Before and After Insert
Before and After Update
Before and After Delete
Database triggers defined using the PROGRESS/400 Data Dictionary apply only to PROGRESS applications and will not fire if data is accessed when running at the host-based (ie RPG) applications.
Database triggers are centralized vs. session triggers defined using the 4GL, which are application specific.
DB2/400 database triggers will fire for both PROGRESS and host-based applications. If both types of triggers are on the same file, unpredictable results might occur.