i have a table named test.having colums c1 & c2. i want to change c1 column to ASCII. from ASCII i need to change EBCDIC.Code:test c1 c2 Raj 1 suresh 2
Please provide the solution for this...
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.