progress odbc trigger

RealHeavyDude

Well-Known Member
Since you don't tell anything about your Progress/OpenEdge version and the type of trigger you mean, I just can speculate that you mean the database triggers defined in the data dictionary for the various high level events on database tables.

These triggers can not be executed in a SQL client. Your only option is to duplicate the logic in stored procedures (depending on the Progress version whether it supports stored procedures) or in your software that uses ODBC/JCBC to connect to the database.

Background information: These triggers can only be executed by Progress/OpenEdge runtime executable (virtual machine). Plus, they are NOT executed by the database engine, they are executed by the client session (be it a GUI, CHR or AppServer client) that changes the database.


Heavy Regards, RealHeavyDude.
 
You have to check documentation on sql92 stored procedures/triggers.

They looks like mixed java + sql code and stored in DB.
 
Top