Null handling in Transfomer

deepa_shenoy · Post by **deepa_shenoy** » Mon Oct 26, 2009 11:16 pm

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

tehavele · Post by **tehavele** » Mon Oct 26, 2009 11:23 pm

In the transformart constraint add below constraints.

Code: Select all

IsNotNull(C_ID) And IsNotNull(A_ID)

deepa_shenoy · Post by **deepa_shenoy** » Mon Oct 26, 2009 11:41 pm

Thank you.

Deepa

chulett · Post by **chulett** » Tue Oct 27, 2009 5:33 am

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))

tehavele · Post by **tehavele** » Tue Oct 27, 2009 6:14 am

No.It's there in 7.5 versions as well. I am working on 7.5.1

ArndW · Post by **ArndW** » Tue Oct 27, 2009 6:52 am

The IsNotNull() just gets compiled to Not(Isnull())

chulett · Post by **chulett** » Tue Oct 27, 2009 7:17 am

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.