Q & A

[DB2] rollback이 되지 않습니다.

Date2012.03.24 / Hit : 5666

안녕하세요

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

  • 대표전화
    1660-1675

  • 기술 문의
    02-6931-1734

  • 오렌지 문의
    070-8666-8175

  • 라이선스 문의
    02-6931-1728