So I was experimenting with the new (ish - new to me) IBM HTTP APIs - e.g. SQL function HTTPPOSTCLOB() for posting a CLOB over HTTP and getting the result into a CLOB. I could not get it to work, I kept getting errors about it not being possible to convert between CCSID 65565 and 1200.
After some googling I found it was because my job CCSID was 65535, which these APIs do not allow. Changing my job CCSID to 37 allowed it to work.
But that means if we wanted to use this function in an actual production program, the job it runs under would need to be CCSID 37, whereas all our production system jobs (batch jobs and user jobs) are currently all 65535.
So I am wondering, what does the job CCSID actually do, and what would be the potential implications of changing a job to run as CCSID 37 instead of 65535?
After some googling I found it was because my job CCSID was 65535, which these APIs do not allow. Changing my job CCSID to 37 allowed it to work.
But that means if we wanted to use this function in an actual production program, the job it runs under would need to be CCSID 37, whereas all our production system jobs (batch jobs and user jobs) are currently all 65535.
So I am wondering, what does the job CCSID actually do, and what would be the potential implications of changing a job to run as CCSID 37 instead of 65535?
Comment