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.

Thanks,
Krishna