|
Can't do that because the delete needs to occur before control is returned to the program. The user (especially this user!) may attempt to upload the same batch again almost immediately. I'm not sure what changed going to V5R1. Maybe it is an activation group issue? It seems odd that I could delete the records using RPG but not SQL. The trigger is an RPG program which checks the type of batch and calls the correct program to delete the records from the appropriate interface file. Pete Hall wrote:
Well, maybe you could sbmjob cmd(strqmqry...). You're not using CL for your trigger are you? CL uses all automatic storage, and everything gets reinitialized every time it gets is invoked. I tried using CL for a format selector program once. The overhead was enormous. 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
