CHANGE the size of datatype using transformation nodes

sandeep87

• August 18, 2009 00:00

• Answered

Follow

Hello
can anybody tell me how to change the datatype of the table column... ie...
if datatype of a column is varchar we have to change it to integer..

can we do this with the transformation node?

• 

  jurban

  • August 20, 2009 13:25

  0

  Comment actions Permalink

  Hello,
  you can use the DB_EXECUTE component to execute basically any SQL. So you can use SQL that changes the column type.
  
  Jaro
• 

  sandeep87

  • August 22, 2009 07:41

  0

  Comment actions Permalink

  is there a node db_execute???? in clover etl?
• 

  jurban

  • August 24, 2009 09:34

  0

  Comment actions Permalink

  Hi,
  yes, there is such a node. See the wiki: http://wiki.clovergui.net/doku.php?id=c ... db_execute
  
  Jaro

Please sign in to leave a comment.