Transformer Null handling and reject link
Moderators: chulett, rschirm, roy
Transformer Null handling and reject link
hello,
i have a problem with Transformer, I would like if a column is null that the row is not rejected.
Can you give me a solution, Which stage use before ?
Thanks
i have a problem with Transformer, I would like if a column is null that the row is not rejected.
Can you give me a solution, Which stage use before ?
Thanks
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
Is a warning or other message being logged? Do you have constraints on the output link? What exactly do you mean by "rejected"?
No-one can know the why unless you provide more information on what you are doing or seeing, right now we'd only be guessing.
No-one can know the why unless you provide more information on what you are doing or seeing, right now we'd only be guessing.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The field in question must be marked Nullable on the output link.
No Transformer function can be supplied with NULL as an argument (this requirement is relaxed, we are informed, in the next version of DataStage). Therefore any incoming NULL must be intercepted and not passed to the function.
If IsNull(InLink.TheField) Then SetNull() Else TheFunction(InLink.TheField)
No Transformer function can be supplied with NULL as an argument (this requirement is relaxed, we are informed, in the next version of DataStage). Therefore any incoming NULL must be intercepted and not passed to the function.
If IsNull(InLink.TheField) Then SetNull() Else TheFunction(InLink.TheField)
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.
Since you already have a transform stage in the job then use that stage and a NullToValue() function.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am