spaces causing null handling issue
Moderators: chulett, rschirm, roy
spaces causing null handling issue
Hello,
In one of our jobs the source data spaces, and datastage is trimming those spaces and making it null and eventually the records are rejected, is there a way to handle that.? i am loading form dataset to oraclae stage.
thanks in advance.
In one of our jobs the source data spaces, and datastage is trimming those spaces and making it null and eventually the records are rejected, is there a way to handle that.? i am loading form dataset to oraclae stage.
thanks in advance.
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm
Thanks Hiral,
That is a notnull field(not a key field), and space is coming into that field from source DB.
we are extracting the table from Oracle ---> Dataset.
and the loading to target table. in btw the space is trimmed in datastage and the field become null, and as the field is not nullable, gets rejected.
some one suggested me to chane the delimiter to pipe but how we can set the delimiter in dataset??
Thanks in advance.
That is a notnull field(not a key field), and space is coming into that field from source DB.
we are extracting the table from Oracle ---> Dataset.
and the loading to target table. in btw the space is trimmed in datastage and the field become null, and as the field is not nullable, gets rejected.
some one suggested me to chane the delimiter to pipe but how we can set the delimiter in dataset??
Thanks in advance.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is offensive. You waited less than two hours. These were the "wee small hours" in my time zone and I was asleep.mekrreddy wrote:Any solutions please???
DSXchange is an all-volunteer site, whose members post when they can, if they have something to say.
If you want rapid response, sign up with your support provider for priority service and learn just how expensive "urgent" really 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.