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?
insert into table using ODBC Stage
-
- Participant
- Posts: 36
- Joined: Tue Sep 16, 2008 12:15 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 36
- Joined: Tue Sep 16, 2008 12:15 pm