|
I have an EDI application that may need to delete multiple records from multiple files with the same key fields Key is Trading Partner and Transaction ID If midway thru Creating records there is an issue with some of the data I.e. Retrieving x-reference Information I would need to Abort this transaction I could perform READE on the files and delete Records, but would performance be better or worse if I ran the deletes via SQL the files would contain Less than a few Thousand records (as these are transactional temp files that are cleared before the process is run) and Records within the key would be between 1-999 depending on which file is being processed for further consideration I am already performing an sql select within the program and the Physical files are currently not keyed but there is a Multiformat Logical over the files with the same key that I would be using for the delete criteria Thanks in Advance -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rpg400-l-request@xxxxxxxxxxxx Sent: Wednesday, March 21, 2007 1:00 PM To: rpg400-l@xxxxxxxxxxxx Subject: RPG400-L Digest, Vol 6, Issue 278 Send RPG400-L mailing list submissions to rpg400-l@xxxxxxxxxxxx To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/rpg400-l or, via email, send a message with subject or body 'help' to rpg400-l-request@xxxxxxxxxxxx You can reach the person managing the list at rpg400-l-owner@xxxxxxxxxxxx When replying, please edit your Subject line so it is more specific than "Re: Contents of RPG400-L digest..."
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.