Constraint Syntax

srinath51 · Post by **srinath51** » Wed Feb 29, 2012 1:19 pm

Hi all,
i have a field Named - "Buss_unit(varchar(5))" which display the values as Null,12,20.

Now my requirement is that i have to define a constraint in the Transformer to Delete the rows with Null values...

Please help me the syntax.

jwiles · Post by **jwiles** » Wed Feb 29, 2012 1:44 pm

The constraints use standard expression syntax as you would use in other transformer derivations. If the expression evaluates as true, the row in question will be sent to the output link.

IsNotNull(inputlink.Buss_unit)

If the column is not null, then the expression evaluates to true and the record passes through to the link.

Regards,

srinath51 · Post by **srinath51** » Wed Feb 29, 2012 2:05 pm

Thanks Jwiles....

macromathi1 · Post by **macromathi1** » Sat Mar 03, 2012 7:28 am

i hope no function exist in the name IsNotNull(), use Not(IsNull(inputlink.Buss_unit))

chulett · Post by **chulett** » Sat Mar 03, 2012 9:23 am

Why the hope? IsNotNull() is a perfectly valid function.

pandeesh · Post by **pandeesh** » Sun Mar 04, 2012 4:10 am

i wonder why people are using

Code: Select all

Not(IsNull(inputlink.Buss_unit))

format. I have also seen in some sites, still people are not much aware of IsNotNull.

chulett · Post by **chulett** » Sun Mar 04, 2012 8:06 am

Probably from people with a Server background as it only exists in the Parallel product. In any case, either way works just fine.