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?
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?
Hello,
you can use the DB_EXECUTE component to execute basically any SQL. So you can use SQL that changes the column type.
Jaro
is there a node db_execute??? in clover etl?
Hi,
yes, there is such a node. See the wiki: http://wiki.clovergui.net/doku.php?id=c … db_execute
Jaro