DSXchange

Hi Guys

I have to do a some sort of validation process in the datastage transformer. The logic to be used is=>

If the input value for one particular column is not "Numeric" then don't move it to the next level or stage. The data which is Numeric is only moved further. I am reading the Data as Varchar. Can anyone suggest what logic I use to produce this kind of output using the constraint of transformer.

Thanks

The function IsValid can be used to check if a value is numeric, I am using Transformer stage variable to keep the result and then it can be used in the constraint condition.

kashif007 wrote:Hi Guys

I have to do a some sort of validation process in the datastage transformer. The logic to be used is=>

If the input value for one particular column is not "Numeric" then don't move it to the next level or stage. The data which is Numeric is only moved further. I am reading the Data as Varchar. Can anyone suggest what logic I use to produce this kind of output using the constraint of transformer.

Thanks

That is exactly what I need but I am not sure how you did that. I am using a logic

IsValid("Numeric", DSLinkname)

Please correct me. I am not getting the right stuff with this logic.

you can also use the NUM function to check whether the source column is numeric or not.It will return 1 if the source column is numeric otherwise it will return 0

Thanks Mansoor. It works.

IsValid("Integer", InLink.TheColumn) is more efficient.

Hi,

You can just put following code in ur constraint to serve ur purpose
num(Field)

num(Field) : Returns True if Field is numeric.