Not only can multiple tables be updated from a single program, If the
tables are all related and logical consistency of the application
requires concurrent updates to all related table rows, then all tables
should be updated from the same program with COMMIT being used
judiciously so that related row changes are committed together.
Since the initial post indicated this is a potentially daily process,
manual methods using SPUFI or other interactive tools to multiple tables
would seem a poor choice.
Long-term, the best solution is still to find some way to change the
process to minimize the entry of bad customer numbers in the first place.
JC Ewing
On 11/21/2012 11:21 AM, Ron Thomas wrote:
Ok. the tables we are are in DB2 and lang we are using is cobol. One another
thing if we want to clean up the 15 tables , can this be done in a single
program or do we need multiple programs. I am thinking of cleaning this in a
single cobol program. any issues with this approach?
Regards
Ron T
--
Joel C. Ewing, Bentonville, AR [email protected]
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
