topic Re: On commit work and LUW... in Application Development and Automation Discussions

On commit work and LUW...

Former Member — Tue, 06 Jun 2006 08:19:21 GMT

hi all,

how do you implement commit work? i have a code more or less like the following:

update db_tab_dtl from table i_dtl.
update db_tab_hdr from table i_hdr.

i want to make sure that both statement commits or rollback if atleast one fails. Sort of like the transaction block in SQL...

regards,

sid

Re: On commit work and LUW...

Former Member — Tue, 06 Jun 2006 08:21:21 GMT

Hi,

first you see if both the internal tables it1 and it2 are populated checking for sy-subrc.

Just give the statement COMMIT WORK after updating the database tables.

update db1 from itab1.
if sy-subrc =0.
update db2 from itab2.
commit work.
endif.

Regards,

Aswin

Re: On commit work and LUW...

Former Member — Tue, 06 Jun 2006 08:21:45 GMT

Hi sid,

1. Simple

2. Just add two / three lines

COMMIT WORK.

update db_tab_dtl from table i_dtl.

if sy-subrc = 0.

update db_tab_hdr from table i_hdr.

COMMIT WORK.

endif.

4. 1st line is optional.

regards,

amit m.

Re: On commit work and LUW...

Former Member — Tue, 06 Jun 2006 08:22:12 GMT

Try this.

update db_tab_dtl from table i_dtl.

if sy=-subrc = 0.

update db_tab_hdr from table i_hdr.

if sy-subrc = 0.

commit work.

else.

rollback work.

else.

rollback work.

endif.

Regards,

Ravi

Re: On commit work and LUW...

Former Member — Tue, 06 Jun 2006 08:24:44 GMT

hi friend,

update db_tab_hdr from table i_hdr.

if sy-subrc eq 0.

update db_tab_dtl from table i_dtl.

if sy-subrc eq 0.

commit work.

else.

rollback work.

endif.

else.

rollback work.

endif.

Hope it solves your purporse..

Reward if helps..

Regards,

Yakub Shah

Re: On commit work and LUW...

Manohar2u — Tue, 06 Jun 2006 08:24:46 GMT

You keep these two statements under


PERFORM UPDATE ON COMMIT.
if status = 0.
commit work.
else.
rollback.
endif.

If everything OK in this perform the commit it else rollback it.

Regds

Manohar

Re: On commit work and LUW...

Former Member — Tue, 06 Jun 2006 08:39:20 GMT

describe i_dtl lines lv_i_dtl.

update db_tab_dtl from table i_dtl.

if sy-dbcnt = lv_i_dtl.

describe i_hdr lines lv_i_hdr.

update db_tab_hdr from table i_hdr.

if sy-dbcnt = lv_i_hdr.

commit work.

else.

rollback.

endif.

else.

rollback.

endif.

Re: On commit work and LUW...

Former Member — Fri, 09 Jun 2006 02:52:09 GMT

thanks to all of you guys!...