is it possible in DATASTAGE??

arnie_nits · Post by **arnie_nits** » Wed Oct 31, 2007 3:53 am

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.

bikan · Post by **bikan** » Wed Oct 31, 2007 4:06 am

Yes.

Use the string functions Alpha and Num in the transformer.

arnie_nits · Post by **arnie_nits** » Wed Oct 31, 2007 4:33 am

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