I have a physical file on the iSeries (V7R1) that I am trying to send to the IFS using CPYTOIMPF. When I open the file on the IFS using Excel I expected to be able to parse the data using "Text to Columns" but the delimiter characters are missing and the text is garbled. Several of the fields contain double byte characters. They are defined with data type "O" (open) and CCSID 65535.
I've tried several combinations of data type and CCSID but all I get is unreadable ASCII text. By the way, I'm trying to use a Japanese character set.
Can anyone lead me through this maze?
Thanks in advance for your assistance.