|
At 13:59 12/11/2002, Michael Smith wrote:
FileA has a trigger program(RPG) that modifies the buffer contents with a unique sequence number. I would like to have this number available to the calling program. Is there a way to accomplish this without storing the value in an object;dataarea, userspace?
Not without re-reading the database row after the update completes. That's really not too terribly resource intensive on a single level storage machine. You could use the user space though. I've done that a few times to control conflicting trigger operations, and it works very well. You create the user space in qtemp, and once the user space pointer is resolved, it's just like accessing shared internal storage that's accessible to both programs. Since the trigger invocation is unique to the job anyway, it's ok to use qtemp, and you don't have to worry about cleaning up at end of job. Pete Hall pbhall@ameritech.net http://www.pbhall.us/
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.
midrange.com
