Calaculating ASCII value in datastage
Posted: Wed Aug 18, 2010 2:38 am
Hi,
We need to get the ASCII values of incoming data to check whether they represent special chareacters.
There seems to be function 'ASCII' and has couple of help pages in DataStage on that; but in tramsformer we are not able to use it. Transformer shows error like ' ASCII not defined.'
So is it like we can use ASCII function only in datastage subroutine or thre is no function called ASCII in datastage. How can i calculate ASCII values of characters in transformer?
Thanks in advance.
We need to get the ASCII values of incoming data to check whether they represent special chareacters.
There seems to be function 'ASCII' and has couple of help pages in DataStage on that; but in tramsformer we are not able to use it. Transformer shows error like ' ASCII not defined.'
So is it like we can use ASCII function only in datastage subroutine or thre is no function called ASCII in datastage. How can i calculate ASCII values of characters in transformer?
Thanks in advance.