Character conversion between CCSID 65535 and CCSID 1208 not valid

I recently received this error when doing an SQL update on a system table.
Changing the JOB CCSID fixed the issue.

CHGJOB CCSID(37)

-- OR --

CHGSYSVAL SYSVAL(QCCSID) VALUE(37)
  • The default QCCSID on the iSeries is 65535. It is recommended that you change this value to your local language. In the United States, the value is 37 which is English.
  • Changing the QCCSID occurs immediately. You do not have to IPL (initial program load) the machine but at the next IPL, this value will be stored.

No comments:

Post a Comment

NO JUNK, Please try to keep this clean and related to the topic at hand.
Comments are for users to ask questions, collaborate or improve on existing.