Re: Trigger question

Alan,

I downloaded and installed your mediator, but I can't seem to get it to
work.

After making some minor modifications to the TS0001 test service program
and adding it to a file, I get the following runtime error:

Ownership of object DBFPARM in QTEMP type *DTAARA changed.
Library TG_CTL_HDR not found.
Application error. CPF9810 unmonitored by XVUSPC at statement 0000000793,
instruction X'0000'.
Function check. CEE9901 unmonitored by TG_MED at statement 0000000628,
instruction X'0000'.
The call to INT_MAINLI ended in error (C G D F).
The call to INT_MAINLI ended in error (C G D F).

I'm using the ready-compiled programs and service programs from the save
file. Our system is V5R3.

Any help is greatly appreciated.

Best regards,


Peter Colpaert
Software Engineer, Consumer Luminaires

Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Tel. +32/ 3 450 74 09, Fax +32/ 3 450 74 33, Internal 1317
peter.colpaert@xxxxxxxxxxx, www.philips.com



The information contained in this message is confidential and may be
legally privileged. The message is intended solely for the addressee(s).
If you are not the intended recipient, you are hereby notified that any
use, dissemination, or reproduction is strictly prohibited and may be
unlawful. If you are not the intended recipient, please contact the sender
by return e-mail and destroy all copies of the original message.






"Alan Campin" <Alan.Campin@xxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
16/05/2008 22:36
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Trigger question

Seriously, I've also been sorely tempted to put surrogates in on not
only my workflow trigger but "inbound interface" triggers, but worry
about the overhead of an additional call, particularly when the

trigger

program itself is sufficiently big and complex to affect performance.

I did not see your original post but I assume you are talking about
using a Trigger Mediator.

If you go to www.think400.dk/downloads.htm and look for Trigger
Mediator, you will find a complete trigger mediator that lives between
database and your program and it is written as a service program to
reduce overhead.

The only caveat I can offer is that it will not work if you are doing
recursive calls. (Your trigger program fires another trigger call). I
need to get it modified to use a small piece of "C" for the program
entrance to handle this but have been too lazy to get it done.

In any case, it is a complete piece of code with screens to maintain the
database of tables names and service programs to call.