Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
4 replies Latest Post - ‏2013-08-16T02:49:23Z by ChuanKaiChen
ChuanKaiChen
ChuanKaiChen
10 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

    Re: CREATE GLOBAL TEMPORARY TABLE do not support ALTER

    ‏2013-08-14T13:44:59Z  in response to ChuanKaiChen

    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
      ACCEPTED ANSWER

      Re: CREATE GLOBAL TEMPORARY TABLE do not support ALTER

      ‏2013-08-15T07:08:57Z  in response to nivanov1

      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
        ACCEPTED ANSWER

        Re: CREATE GLOBAL TEMPORARY TABLE do not support ALTER

        ‏2013-08-15T12:21:59Z  in response to ChuanKaiChen

        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
          ACCEPTED ANSWER

          Re: CREATE GLOBAL TEMPORARY TABLE do not support ALTER

          ‏2013-08-16T02:49:23Z  in response to nivanov1

          Thanks for your comments, Nivanov