View previous topic :: View next topic |
Author |
Message |
SRI123 Beginner
Joined: 01 Jun 2012 Posts: 18 Topics: 7
|
Posted: Mon Apr 28, 2014 11:47 am Post subject: How to change CCSID value |
|
|
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. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
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
Code: |
//PRECOMP EXEC PGM=DSNHPC,PARM='CCSID(1208)'
|
DB2 coprocessor
Code: |
//COBPRC EXEC PGM=IGYCRCTL,PARM='SQL,CODEPAGE(1208)'
|
Kolusu |
|
Back to top |
|
|
SRI123 Beginner
Joined: 01 Jun 2012 Posts: 18 Topics: 7
|
Posted: Mon Apr 28, 2014 9:11 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
William Collins Supermod
Joined: 03 Jun 2012 Posts: 437 Topics: 0
|
Posted: Tue Apr 29, 2014 4:12 am Post subject: |
|
|
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. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Tue Apr 29, 2014 10:32 am Post subject: |
|
|
SRI123 wrote: | Thanks for reply, but how to change the values permanently? |
Sri123,
Specification of CCSIDs is performed at installation via install Panel DSNTIPF. If you want a permanent change then you need to have admin rights which obviously you don't have.
SRI123 wrote: |
And also what is the meaning of 500 & 1208? Which one should be used?
|
Look up this link which explains all the CCSID's
http://www.ibm.com/software/globalization/ccsid/ccsid_registered.html
SRI123 wrote: |
Which one should be used?
|
Each site is different and you just need to talk to your systems admin and figure out which one to use. |
|
Back to top |
|
|
SRI123 Beginner
Joined: 01 Jun 2012 Posts: 18 Topics: 7
|
Posted: Tue Apr 29, 2014 8:37 pm Post subject: |
|
|
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?
Code: |
7 EBCDIC CCSID ===> CCSID of SBCS or mixed data. 1-65533.
8 ASCII CCSID ===> CCSID of SBCS or mixed data. 1-65533.
9 UNICODE CCSID ===> 1208 CCSID of UNICODE UTF-8 data.
|
Thanks |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Wed Apr 30, 2014 11:37 am Post subject: |
|
|
SRI123 wrote: | 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?
|
Sri123,
It totally depends on your environment like you MIXED or NON-MIXED Systems defined in DSNHDECM. If you have system with MIXED=NO, then you can specify 819 and 37 for the ASCII and EBCDIC Single byte CCSIDs and that DB2 used the value 65534 for the ASCII and EBCDIC Mixed and Graphic (Double byte) CCSIDs. 65534 is a reserved value that means no CCSID.
Btw I suggest that you read this presentation. What’s a CCSID and why do I care? |
|
Back to top |
|
|
|
|