Page 1 of 1

insert into table using ODBC Stage

Posted: Mon Feb 22, 2010 12:42 pm
by tatikramos
Hello,
I have a couple server jobs simple pulling data from DB2 plugin --> inerting it into odbc stage --sql server table. for some reason the odbc stage is if the source column has a null value the odbc stage will insert a special character. do i need to change some settings so i can avoid this?

Posted: Mon Feb 22, 2010 3:27 pm
by ray.wurlod
Are you using WebSphere Transformation Extender (formerly DataStage TX)? Because that's what this forum covers.

If not, please post in the appropriate forum, so that we understand better whether this is a parallel job, a server job or whatever it is.

Posted: Mon Feb 22, 2010 3:51 pm
by tatikramos
i am using datastage enterprise edition. and my job is a server job. if ia m in the wrong forum is there anywya you can transfer this one to the server o should i close it and create a new one on server forum?