Hello,

My purpose is to verify COMMIT and ROLLBACK transaction in DB2.
I created a table, then inserted a record into it. After that, I updated the record with a new value, then did ROLLBACK as below:

retcode = SQLEndTran(SQL_HANDLE_DBC, dbc, SQL_ROLLBACK);

it returned successfully, but when I checked the record, it still updated with the new value. I expected the record wouldn't be updated.

Do you know what's wrong?

Is it because autocommit is set to on? How do I set if off both in coding and command line?

Thanks
Keegan

It is most probably due to autocommit. Turning it off in coding depends on the language you are using. For the CLP you can issue:
UPDATE COMMAND OPTIONS USING C OFF

HTH

Andy

Thanks, Andy.