var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Rollback didn't work
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?
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