4 Replies Latest reply on Feb 23, 2015 5:28 AM by Steven Hawkins

    Is it possible to change a column's data type using DDL statements in the VDB after it's been loaded natively?

    Michael Farwell Newbie

      Is it possible to change a column's data type using DDL statements in the VDB after it's been loaded natively by the translator?

       

      We have a column that is being created as a string by a custom translator.  We'd like
      to make it into a clob using DDL statements in the VDB. 

       

      Something like the following:

       

      <metadata type="NATIVE,DDL">

                      <![CDATA[

                      ALTER FOREIGN TABLE "points" ALTER COLUMN "timestamps" OPTIONS(SET DataType 'clob');

                      ]]>

              </metadata>

       

      The translator's metadata processor creates the "timestamps" column as a string, but it's not big enough.  We need it to be a clob.  How do we override the datatype selected by the translator?

       

      Thanks!