Conversion of string to ASCII & ASCII to EBCDIC

**santu4483** · 01-30-2013, 02:53 AM

Hi,

i have a table named test.

Code:

test
                                               c1          c2
                                                Raj         1
                                                suresh     2

having colums c1 & c2. i want to change c1 column to ASCII. from ASCII i need to change EBCDIC.
Please provide the solution for this...

Regards,
Santosh

**vijay** · 01-31-2013, 04:26 AM

As far as i know there is no feature in netezza which can be used to convert a whole string to ASCII format. Write a function to covert each character to ASCII and then convert to EBCDIC.