update table with more records

IBM's flagship relational database management system

Re: update table with more records

Postby Akatsukami » Fri Jan 25, 2013 1:27 am

dick scherrer wrote:Howdy,

Thanks for the clarification - my dain brammage never got there . . .

So the "file" could have been read and the SQL generated into a temporary file, then run in a second step that executed these update queries (i.e. "batch" SPUFI). . .?

Yes. Although I believe that some of my peers are of the opinion that that doesn't create the necessary audit trail ;) I don't claim that I've provided an adequate trail, but I've at least tried to acknowledge the need for one.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Global moderator
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: update table with more records

Postby dick scherrer » Fri Jan 25, 2013 2:08 am

Many of the places i've supported do not allow "on the fly" changes to production data via QMF, SPUFI, etc.

They do support running canned generalized code that will perform these updates as well produce audit trails that are acceptable for that organization. These are scheduled as regular production and have "real" jobnames.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2


  • Related topics
    Last post