Joined: 14 Jan 2008 Posts: 2501 Location: Atlanta, Georgia, USA
Can Anybody tell me how to convert ASCII to a character. I want Character equivalent of a known ascii say 65 which should return 'A' for me.
I tried CHR SQL function, but it is giving error.
If I'm understanding you correctly, you would build your FROM-TABLE using ASCII data and build your TO-TABLE with your equivalent EBCDIC data and issue an INSPECT "data to be converted" CONVERTING FROM FROM-TABLE TO TO-TABLE.
Check with your shop if they already have routines at hand for converting ASCII to EBCDIC.
You should verify if the codepage used on the sending (ASCII) system matches the translation table. I will assume that the EBCDIC table offered (teh TO-values) will match the code page of the receiving system.