Skip to Content
0
Former Member
Dec 08, 2006 at 05:03 PM

What if program with 'INSERT into TABLE' fails

62 Views

Hello All,

My program has insert and update to database tables. What happends if my program crashes in the middle? How to COMMIT this transactions to DB table, only after executing whole program?

example:

....

....

LOOP AT itab.

IF x = 100.

UPDATE zdbtable

SET date = sy-datum

userid = ''

WHERE sno = '100'.

ELSEIFx = 200.

UPDATE zdbtable

SET date = sy-datum

userid = ''

WHERE sno = '200'.

ELSEIF lv_days_pending = 300.

int_dbtable-sno = '300'.

int_dbtable-userid = ''.

INSERT into zdbtable values int_dbtable.

DELETE

FROM zdbtable

WHERE sno = '100'

ENDIF.

ENDLOOP.

I would like all this data base transactions to be executed or else if there is any crash in the middle no chages has to be made to the database tables.

Thanks,