Need help with Triggers and UDF
The main problem is we are trying to port an existing Oracle application into
DB2. In Oracle we used triggers extensively. We have cursors defined inside
the triggers. Because I couldn't find a way to define cursors or any variables
to that extent other than transition variables with in DB2 triggers I am
considering to use stored procedures or UDF's instead.
1) Can I call a stored procedure from a trigger. If so how can I do that?
2) If I can't call a stored procedure, and all I can call is a UDF, Is there
any way to convert the existing files (.c, .sqc, .dll) of a particular stored
procedure to relate to a UDF.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL