DSXchange

Hi,

My source table has a varchar field. And it propagates either alphabatic or numeric value in it (like 'ABG' and '123').
Now in the transformer stage I have to check whether it is alphabatic or numeric ...i.e 'asd' or '412'......

Is it possible in datastage.....Kindly let me know...

regards
Arnie.

Yes.

Use the string functions Alpha and Num in the transformer.

got it....thank you very much ........