Topic
  • 4 replies
  • Latest Post - ‏2013-08-16T02:49:23Z by ChuanKaiChen
ChuanKaiChen
ChuanKaiChen
10 Posts

Pinned topic CREATE GLOBAL TEMPORARY TABLE do not support ALTER

‏2013-08-14T06:35:50Z |

-- Oracle SQL
CREATE  GLOBAL TEMPORARY  TABLE T
(
ID INT ,
USERNAME VARCHAR2(60) WITH DEFAULT 'YY'
)
;

 -- IDMT get the SQL from Oracle database like this:
CREATE  GLOBAL TEMPORARY  TABLE T
(
ID INT ,
USERNAME VARCHAR2(60)
)
;

ALTER TABLE T ALTER COLUMN USERNAME SET WITH DEFAULT 'YY';

 

But, DB2 do not support ALTER for a CGTT.

Is this a IDMT bug?

  • nivanov1
    nivanov1
    22 Posts

    Re: CREATE GLOBAL TEMPORARY TABLE do not support ALTER

    ‏2013-08-14T13:44:59Z  

    You may want to consider using the IBM Database Conversion Workbench for Oracle database migration -- it is the currently supported tool.

  • ChuanKaiChen
    ChuanKaiChen
    10 Posts

    Re: CREATE GLOBAL TEMPORARY TABLE do not support ALTER

    ‏2013-08-15T07:08:57Z  
    • nivanov1
    • ‏2013-08-14T13:44:59Z

    You may want to consider using the IBM Database Conversion Workbench for Oracle database migration -- it is the currently supported tool.

    Yep.

    We are using both DCW and IDMT.

    For DB2 10.1, we use DCW. For DB2 9.7, we use IDMT. As the DCW looks not supporting 9.7.

  • nivanov1
    nivanov1
    22 Posts

    Re: CREATE GLOBAL TEMPORARY TABLE do not support ALTER

    ‏2013-08-15T12:21:59Z  

    Yep.

    We are using both DCW and IDMT.

    For DB2 10.1, we use DCW. For DB2 9.7, we use IDMT. As the DCW looks not supporting 9.7.

    The most recent version of the DCW supports current DB2 versions: 10.1 and 10.5. For DB2 9.7 support you'll need to use an earlier version of the DCW, I think 1.2 should do the trick.

  • ChuanKaiChen
    ChuanKaiChen
    10 Posts

    Re: CREATE GLOBAL TEMPORARY TABLE do not support ALTER

    ‏2013-08-16T02:49:23Z  
    • nivanov1
    • ‏2013-08-15T12:21:59Z

    The most recent version of the DCW supports current DB2 versions: 10.1 and 10.5. For DB2 9.7 support you'll need to use an earlier version of the DCW, I think 1.2 should do the trick.

    Thanks for your comments, Nivanov