MVSFORUMS.com

SRI123 · Beginner Joined: 01 Jun 2012 Posts: 18 Topics: 7

i

In precompile CCSID 500 is used, and during bind ENCODING UNICODE(1208) is used. Because of this data is converting to different format.

How to change the CCSID from 1208 to 500?
( Note: No admin help, I have the admin rights. so based on suggestions I can change the values, this is a test region..)

Thanks in advance.

kolusu · Posted: Mon Apr 28, 2014 12:00 pm Post subject:

SRI123,

What are you using ? DB2 precompiler or DB2 coprocessor? Both of them have an override of CCSID/CODEPAGE via parm.

DB2 precompiler override

SRI123 · Beginner Joined: 01 Jun 2012 Posts: 18 Topics: 7

Thanks for reply, but how to change the values permanently? And also what is the meaning of 500 & 1208? Which one should be used?

Thanks

William Collins · Supermod Joined: 03 Jun 2012 Posts: 437 Topics: 0

You should talk to the technical staff at your site. Remember it will need to be consistent across all your environments, up to and including Production, but not affect other systems. The numbers are just codes for different character-sets, effectively. Different encodings, different human languages. When data arrives from "somewhere" it is one thing, you may process it as another, and pass it on somewhere else to display it. Then it comes back the same way. Through six conversions, an accented character e must remain that (logically or physically), as must everything else.

You should be glad to get rid of this to your techies, and happy to have enough knowledge to notice if they get it wrong.

kolusu · Posted: Tue Apr 29, 2014 10:32 am Post subject:

SRI123 · Beginner Joined: 01 Jun 2012 Posts: 18 Topics: 7

Thanks for reply.

I have admin rights( this is training environment).

Since my precompilation has CCSID 500, what is the value need to enter for below 7, 8, 9 fields?

kolusu · Posted: Wed Apr 30, 2014 11:37 am Post subject: