topic Re: Commit Work Issue in Application Development and Automation Discussions

Commit Work Issue

Former Member — Fri, 20 Jan 2012 07:50:09 GMT

Hi.

I am modifing a ztable in a user exit, but this ztable gets updated in production server only 70-80 percent.

But i haven't written any commit work after modify statement.

Not writing COMMIT WORK after modify, is the reason why ztable doesn't update in some occassions.

Re: Commit Work Issue

Former Member — Fri, 20 Jan 2012 07:53:10 GMT

Hi,

COMMIT WORK is not necessary for Modifying ZTables. check any conditions are involved for modifying Ztable.

Re: Commit Work Issue

madhu_vadlamani — Fri, 20 Jan 2012 07:57:32 GMT

HI,

Why commit statement to update ztable.

Regards,

Madhu.

Re: Commit Work Issue

Former Member — Fri, 20 Jan 2012 07:59:52 GMT

thanks

Re: Commit Work Issue

lijisusan_mathews — Fri, 20 Jan 2012 08:04:54 GMT

IF you modify Database Records, you have to commit to write the changes . It can give error cases situations otherwise

Re: Commit Work Issue

lijisusan_mathews — Fri, 20 Jan 2012 08:10:49 GMT

I have had scenario where I had to update My Z table . This updation was to be followed by a refresh and re-display of this table.

Initially , I had not written any commit statement.

And after some time, It started showing errors. The data never got re displayed properly as the data was not getting updated. We tried debugging and it was working fine then. So we could not identify the problem. Then we wrote COMMIT WORK and also called WAIT UP TO 2 secs. That solved my issue. So , since then I was under the impression that custom table changes need to be Committed too. Please share if you have some information regarding the same.

Suzie