CHANGE the size of datatype using transformation nodes

CloverDX Platform
1

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?

2

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

Jaro

3

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

4

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

Jaro