Function alpha and Alnum

Javieregh · Post by **Javieregh** » Fri Sep 17, 2010 5:14 am

Hi All,

I need any functions or suggestions to implement the AlNum and Alpha operator in datastage.

Eg. if Alpha(table.column) = 1 then 0 else 1 or if AlNum(table.column) then 0 else 1

I need return when the column is invalid Alpha and also Alnum.

Any inputs most appreciated.

Regards,
Xavi

chulett · Post by **chulett** » Fri Sep 17, 2010 5:53 am

Have you not been through the functions listed in the documentation, either in the online help or in the suppiled pdfs? In addition to the ones you've been asking about, there is an IsValid function you should check out as well.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 17, 2010 6:15 am

Alpha(), AlNum() and Num() all exist.

chulett · Post by **chulett** » Fri Sep 17, 2010 6:43 am

Exactly, which a quick check of the documentation would easily reveal.