Support
Orange Support > 문의하기
Q & A
[DB2] rollback이 되지 않습니다.
안녕하세요
Orang for DB2를 사용중인데.
rollback이 되지 않고 무조건 auto commit 됩니다.
파일첨부가 되지 않아
== 오렌지실행결과 ===
SQL> select * from emp where mgrid = '10';
EMPNO NAME SALARY MGRID FIRSTNAME DEPNO WORKEDPT WORKDEPT REGION SEX
---------- ---------- --------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
2 Hall 700.00 10
3 Kim 700.00 10
4 Lindsay 700.00 10
3 rows selected.
SQL Execution Time > 00:00:00.000
Total Elapsed Time > 00:00:00.000
-------------------------[Start Time: 2012/03/24 17:28:37]-------------------------
SQL> update emp set salary = 10 where mgrid = '10';
3 rows Updated.
SQL Execution Time > 00:00:00.000
-------------------------[Start Time: 2012/03/24 17:28:37]-------------------------
SQL> rollback;
Rollback Complete.
SQL Execution Time > 00:00:00.063
-------------------------[Start Time: 2012/03/24 17:28:37]-------------------------
SQL> select * from emp where mgrid = '10';
EMPNO NAME SALARY MGRID FIRSTNAME DEPNO WORKEDPT WORKDEPT REGION SEX
---------- ---------- --------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
2 Hall 10.00 10
&n
[DB2] rollback이 되지 않습니다.
kwindow2
2012.03.24
Re: [DB2] rollback이 되지 않습니다.
오렌지팀
2012.03.27