Q
Problem solve Get help with specific problems with your technologies, process and projects.

Converting files from a CCSID 65535 code page to 37

We are trying to convert files from a CCSID 65535 code page to 37. Even changing things at a system level has not...

fixed our problem - we cannot view the files from DB2 Connect or even MS Access. Can you provide insight on how to convert this?


DB2 is on AS400 V4R2. Using version 5 of DB2 Connect.

I can't understand -- Did you manage to change the CCSID? If not this will not work correctly unless DB2 connect has a "translate 65535" flag similar to the client access ODBC driver.

(One reason for failure to change file's ccsid from 65535 is ccsid tag in the field level.)

BTW - did you try to work with the free Client Access ODBC driver? It works fast and there is a big knowledge base regarding it's usage.


Dig Deeper on FTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close