Converting from CCSID 65535 to ASCII

[Michael Franchino]

I am very new to this, all the tables are setup as 65535, my profile is setup with CCSID of 37,

I don't know if I missed the documentation or what, but when I do the retrieve, I am getting back an array of EBCDIC values. How do I force it to convert to ASCII?

I read through the issues but didn't see anything that gave this away.

[Michael Franchino]

My issue is that ALL the tables are coded as *HEX, which is CCSID 65535. After I change the file to CCSID, everything is working. Not sure what to do, as I am not sure that changing EVERY table for MAPICS is going to be ok.