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,