×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I have a trigger program where updates to the table could come from:
1. The general application / support staff OR
2. An Application Server processing messages coming in from an external
system.
- If an update is caused by 1. then message needs to be sent out to the
external system.
- If an update is caused by 2. then the external system instigated the
update and therefore does not require a message.
A given trigger program can always determine the Application Server program
relevant to the file it's on and therefore one way to determine if it is
case 2 would be to check if that program was in the call stack, by using an
API ( quite expensive I think? ) or trying to send a message to a Program
Queue of that name ( will fail if it's not in the call stack )
These seemed like OK solutions if they could be done once at initialisation
and remembered, but that's not a great idea in a trigger program...
And I fear that the call stack one is a bit expensive to do every time and
the program message one will fill up the joblog....
So I'm wondering about other non-expensive ways to determine in the trigger
program if it needs to send out a message. Some simple but not foolproof
things that occur to me are:
- Job User or Name if this can be guaranteed to only be used in case 2.
- Jobs in case 2 will have their own subsystem but I can't see that
attribute on the QWCRTVCA API.
- Accounting Code seems to be linked to User Profile or JOBD and can't
be changed on the fly.
Anyone know of a very inexpensive way to tag a job that could be utilised
in a trigger program.
Thanks and regards,
Craig
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.