View previous topic :: View next topic |
Author |
Message |
Anand_R Intermediate

Joined: 24 Dec 2002 Posts: 189 Topics: 60
|
Posted: Wed Feb 12, 2003 12:21 pm Post subject: Rollback in IDMS |
|
|
Hi
I have a program,,which access the IDMS database, inut is acct no file and for each acct it will update the 3-4 idms records.. and suppose for particular acct it had updated the 2 records and while trying to update 3 rd record I found that it was not the proper acct to be used(I cannot check this condition before I start updating )... so Is there anyway that I can rollback only the changes that were done to that particular acct and continue for other accts, all currencies and run unit bind should be there(basically skip that acct)... job is running in local mode
will rollback work there...
Any help is highly appreciated..
Thanks
anand |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Wed Feb 12, 2003 5:45 pm Post subject: |
|
|
Anand,
You can define working storage array for the 3 or 4 records that you want to update. After finishing all your validation perform the update if it is a valid updatable record.If not just initialize the working storage array.
Hope this helps...
cheers
kolusu |
|
Back to top |
|
 |
Manas Biswal Intermediate

Joined: 29 Nov 2002 Posts: 382 Topics: 27 Location: Chennai, India
|
Posted: Thu Feb 13, 2003 4:08 am Post subject: |
|
|
HI Anand,
Is that a batch program that you are using or you are using some transaction processor like CICS?
Regards,
Manas |
|
Back to top |
|
 |
Anand_R Intermediate

Joined: 24 Dec 2002 Posts: 189 Topics: 60
|
Posted: Thu Feb 13, 2003 5:35 am Post subject: |
|
|
Thanks for ur early response..
Kolusu,
I have just provided the example, but there's lot of logic & lot more idms records updation involved.. So I don't think so I can keep track of them..
Minas,
It's batch programming only ... no CICS/ADSO involved..
What exactly ROLLBACK willdo in local mode .. is it rollback all the changes that were done so far in that module?... pls explain me ..
Thanks
Anand |
|
Back to top |
|
 |
Anand_R Intermediate

Joined: 24 Dec 2002 Posts: 189 Topics: 60
|
Posted: Fri Feb 21, 2003 10:49 am Post subject: |
|
|
Hi,
Did anyone have any suggestions on this..
Thanks
Anand |
|
Back to top |
|
 |
Glenn Beginner
Joined: 23 Mar 2003 Posts: 56 Topics: 3
|
Posted: Sun Mar 23, 2003 7:09 am Post subject: |
|
|
COMMIT will commit all the changes made to that point in the module.
ROLLBACK will rollback all changes made to that point in the module since the last COMMIT. |
|
Back to top |
|
 |
SP Beginner
Joined: 12 Dec 2002 Posts: 2 Topics: 0 Location: India
|
Posted: Sat May 31, 2003 4:59 am Post subject: |
|
|
You can COMMIT after each record. And do a ROLLBACK for the account that you dont want to update. COMMIT after each record will take up more time but if that is what you want, then that is what you will have to do.  _________________ Have fun while programming. |
|
Back to top |
|
 |
|
|