Skip to Content
0
Dec 04, 2009 at 10:17 AM

Reg:Commit and Roll back

31 Views

Hi all,

Im bit confused with transactional concepts commit work/rollback work.

In below program after the insert statement the data is written into db, and after rollback the data is taken back from db

wa-Z_DEPT = 'IWW'.

wa-Z_DEPTNO = '1TT'.

ZAA_EMP = wa.

insert ZAA_EMP.

ROLLBACK WORK.

in the below program the data is not taken back from db after roll back when i give a commit after insert.

insert ZAA_EMP.

COMMIT WORK.

ROLLBACK WORK.

Is it mandatory to commit after a insert statement.

Is it possible to rollback after a commit.

Is there no implicit commit happening after the insert statement.

Anybody there please clear my doubts.

Regards,

Keshu