Hi All,
I want to give this condition in the Constraint tab of Transformer:
C_ID IS NOT NULL AND A_ID IS NOT NULL
How do I give this in DataStage?
I want the Transformer to pass those records which don't have NULLs in their IDs.
Thanks in advance.
Deepa
Null handling in Transfomer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
In the transformart constraint add below constraints.
Code: Select all
IsNotNull(C_ID) And IsNotNull(A_ID)
Tejas
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
I'm assuming that's new syntax in 8.x or perhaps custom work. For earlier versions the answer would be:
Code: Select all
Not(IsNull(C_ID)) And Not(IsNull(A_ID))
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
The IsNotNull() just gets compiled to Not(Isnull())
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
You mean it's a transform? One I've yet to notice after all this time? Sheesh.
Edit: OK, I feel a little better here - there's no such thing in my 7.5.2 installation. It would be easy enough to whip one up, you sure that's not custom work?
Now, there is such a thing in a Parallel Transformer, but not in Server, and since this was marked as a Server question my answer stands.
Edit: OK, I feel a little better here - there's no such thing in my 7.5.2 installation. It would be easy enough to whip one up, you sure that's not custom work?
Now, there is such a thing in a Parallel Transformer, but not in Server, and since this was marked as a Server question my answer stands.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers