Calling UBE from TERs

[ringerike]

Hello,
Is it possible to call an batch application from TERs? I need to call/launch UBE after some records are updated or inserted. I tried some BSFN(like B9800240"Call UBE Application" and B91300C"Launch Batch Application"),but they didn't work.
Any advice would be appreciated.

Thanks in advance,

ringerike

 

[Larry_Jones]

Ringerike,

since no one else responded I will.

Running a program from a Table Trigger (TER) is generally a bad idea. Consider what would happen if a thousand inserts/updates from multiple sources all tried to occur in the same 10 seconds?

Rather, the way to accomplish what you seem to want is to have your TER write the relevant data to another table (a transaction queue table) which is monitored by a program (sub-system job or ube that runs periodically). That program then can be responsible for performing the action desired using the information in the "transaction queue" table.

Regards,