× 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.



my stored procedure program is taking too long....
has someone created a trigger that is just using the QSNDDTAQ api?

so then I can have a nep running to receive and process these entries?



On Thu, Dec 15, 2016 at 1:11 PM, Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx
wrote:

I found an example (that doesn't work...)
create trigger gemlib.iimtrgr1
after update of IDESC , IUMS, IUMP, IITYP
on gemlib.iim
REFERENCING NEW as n
FOR EACH ROW
BEGIN ATOMIC
CALL KSQLLIB.UPDIIMDTA1 (n.IPROD) ;
END

the above fails saying "variable IPROD not found or usable"...

however, If I do this:

create trigger gemlib.iimtrgr1
after update of IDESC , IUMS, IUMP, IITYP
on gemlib.iim
REFERENCING NEW as n
FOR EACH ROW
BEGIN ATOMIC
Declare iprod15 CHAR(15) ;
SET iprod15 = n.IPROD;
CALL KSQLLIB.UPDIIMDTA1 (iprod15) ;
END

that works....
But that seems like I am overdoing it....




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.