rollback은 당연히 됩니다..

저두 잘몰라서 뉴스그룹을 뒤졌습니다.

참고하세요...

질문글입니다..

I have multiple inserts for a transaction and submitting them through

odbc.

I would like to make these atomic by commit them only if all is good

and rollback if an error occur.

I issued a commit work at the end of my insertions; when there is an

error, I submit a rollback work statement; but this does not seem

to cause the entire set to backout.

How do I commit and rollback via odbc ?

Thanks.

## 답글 1..

보낸 사람: "Serge Rielau" <srielau@ca.ibm.com>

제목: Re: how to do commit and rollback in db2

날짜: 2001년 5월 3일 목요일 오전 10:44

Hi Mary,

It seems like you are running under auto commit mode.

Not sure where you set this mode, maybe db2cli.ini (?)

Cheers

Serge

Hi Mary,

It seems like you are running under auto commit mode.

Not sure where you set this mode, maybe db2cli.ini (?)

Cheers

Serge

####답글 2

That's how you do it, but you have to make sure that you turn

"autocommit" off for the ODBC connection.

--

Lorne Sunley

간단한 영어니깐..이해가 되시리라고 믿습니다...이만...

>>급급이 님께서 쓰시길<<

::

:: 아! 아무리 찾아봐도 없는데...

::

:: DB2에서 ROLLBACK이 안 되나요?

::

:: 된다는 얘길 들은것 같은데...

::

:: 된다면 어디에서 설정을 해 주어야 한나요???