topic Re: Database Commit in Application Development and Automation Discussions

Database Commit

Former Member — Thu, 19 Nov 2009 07:48:42 GMT

Hi All,

i need to insert a line item in my ztable.

for some reason, sometimes it works, sometimes it doesn't.

i already added the commit work, still, same thing happens.

when i run it through debug mode, the database gets updated successfully.

but when i run the program i made, it does not update.

if sy-subrc eq 0.

insert into ztab_equip values wa_ztab.

commit work.

else.

delete from ztab_equip

where begda eq is_header_dialog-gstrs and

aufnr eq is_header_dialog-aufnr and

equnr eq ly_equnr.

commit work.

endif.

is there anything else that i need to add? or do i need to use commit work and wait.

thanks!

-jo

Re: Database Commit

Former Member — Thu, 19 Nov 2009 07:57:16 GMT

Hi,

Add a Wait statement before the Commit work

Wait 2 seconds.

Commit work.

Hope this should work fine.

Thanks

Guru

Re: Database Commit

RaymondGiuseppi — Thu, 19 Nov 2009 08:08:05 GMT

Try to call the FM DB_COMMIT. ([Database Commit |http://help.sap.com/abapdocu_70/en/ABENDB_COMMIT.htm])

Regards,

Raymond

Re: Database Commit

Former Member — Thu, 19 Nov 2009 08:11:47 GMT

Hi Geniusrain,

Why dont you try MODIFY & then do database commit with wait.

IF sy-subrc EQ 0.
  MODIFY ztab_equip FROM wa_ztab.
  COMMIT WORK.
ELSE.
  DELETE FROM ztab_equip
  WHERE begda EQ is_header_dialog-gstrs AND
  aufnr EQ is_header_dialog-aufnr AND
  equnr EQ ly_equnr.
  COMMIT WORK.
ENDIF.

Kindly set to resolved if it helps you.

Regards

Abhii...

Edited by: Abhii on Nov 19, 2009 9:12 AM

Re: Database Commit

Former Member — Thu, 19 Nov 2009 08:23:42 GMT

Hi All,

Thank you for your inputs.

But unfortunately, i still get the same result.

Sometimes it updates, sometimes not.

Any other ideas?

Re: Database Commit

JackGraus — Thu, 19 Nov 2009 08:53:00 GMT

Your database table is only updated when SY-SUBRC eq 0. So your database table might not be updated because the statement(s) before this code fragment is(are) not executed succesfuly giving SY-SUBRC ne 0.

Regards Jack

Re: Database Commit

Former Member — Thu, 19 Nov 2009 08:56:42 GMT

Hi Jack,

I tried putting that statement already.

insert into ztab values of wa_tab.

if sy-subrc ne 0.

commit work and wait.

enif.

so that if the insert command didnt work and returned a subrc ne 0, i can do commit and maybe it will write.

what bugs me is that when i pass the codes on debug mode, it works perfectly.

but when i just execute it. it does not perform as i expected/coded it to be.

Re: Database Commit

former_member217544 — Thu, 19 Nov 2009 09:01:18 GMT

Hi,

You should keep commit for success of insert.


insert into ztab values of wa_tab.

if sy-subrc eq 0. " it should be eq
commit work and wait.
wait upto 2 sec.
endif.

Regards,

Swarna Munukoti

Re: Database Commit

RaymondGiuseppi — Thu, 19 Nov 2009 09:08:44 GMT

Did you actually check the record did not exist before inserting in database. If INSERT returns a sy-subrc = 4, then there is already a record with the same primary key. Also there may be garbage in the work area that is rejected by the SQL system (check via SM21)

If you have a duplicate key or invalid data (for database) no commit will correct it for you.

Regards,

Raymond

Re: Database Commit

Former Member — Thu, 19 Nov 2009 09:26:30 GMT

Hi Swarna.

I think your proposed solution solved it.

But i will still test it further in QAS.

Thank you!

Regards,

Joan