DSXchange

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

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.

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

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