Kbase P13162: Can Progress 4GL / ABL database schema triggers fire in response to SQL-92 database events ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/11/2007 |
|
Status: Verified
GOAL:
Can Progress 4GL / ABL database schema triggers fire in response to SQL-92 database events ?
GOAL:
Can 4GL /ABL triggers be executed by SQL clients ?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
No, 4GL database schema triggers fire only in response to 4GL generated database event and SQL-92 database schema triggers fire only in response to SQL-92 generated database events.
The SQL-92 schema triggers are Java stored procedures that are invoked when certain database events occur (INSERT, UPDATE, and DELETE).
The SQL-92 engine executes the SQL-92 schema triggers on the server side. Like other Java stored procedures, the SQL-92 schema triggers are stored in the database.
Designing the SQL-92 schema triggers code consists of writing the Java code that defines what the application does when a certain SQL-92 database events occurs.
Since the 4GL and the SQL-92 engines are two different and independent processes, the SQL-92 database schema triggers do not fire in response to a 4GL client database event, nor do the 4GL database schema triggers fire in response to an SQL-92 client database event.
If the same database MUST be accessed by both SQL-92 and 4GL clients then both sets of schema triggers must be implemented to ensure database integrity.