| View previous topic :: View next topic |
| Author |
Message |
pcmoonbeam
Beginner
Joined: 21 Nov 2005
Posts: 31
Topics: 10
Location: Orange County, California
|
 Posted: Mon Dec 30, 2013 2:03 pm Post subject: SELECTIVE COMMIT |
 |
|
Is it possible to selectively commit work for individual tables within a COBOL batch DB2 program? I have a program that updates several tables, but I would like to commit only a few tables. This is a posting program which adds new participants to a database, so regardless of whether or not their other data is posted, I need their membership information to post. 
_________________
Thanks,
PCMOONBEAM |
|
| Back to top |
|
 |
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
| Posted: Mon Dec 30, 2013 4:07 pm Post subject: |
|
|
Not that i'm aware of.
You could write these entries to a temporary table, issue the commit and then add them to the "real" table, delete the temporary entries and commit.
_________________
All the best,
di
Last edited by papadi on Tue Dec 31, 2013 12:27 pm; edited 1 time in total |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Tue Dec 31, 2013 11:22 am Post subject: Re: SELECTIVE COMMIT |
|
|
| pcmoonbeam wrote: | | Is it possible to selectively commit work for individual tables within a COBOL batch DB2 program? I have a program that updates several tables, but I would like to commit only a few tables. This is a posting program which adds new participants to a database, so regardless of whether or not their other data is posted, I need their membership information to post. |
pcmoonbeam,
Update the tables you want to commit and store the other information in working storage area or temp table and then issue the commit. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
