| Author |
Message
|
| jjanki |
 Posted: Fri Jun 23, 2006 5:35 am Post subject: mqseries ccsid 500 vs 37 character code set. |
 |
|
Newbie
Joined: 26 May 2006
Posts: 6
|
Has anyone converted from CCSID 500 to 37. There are some Hex characters which fail to be read as CCSID 37. Such as X'BE' .
What should I do, where is my thinking screwed up ?
The direction I am going is to modify all qmanagers to CCSID 37 at once, if I absolutely need to do this for the DB2 version 8 software. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Jun 23, 2006 2:16 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Right problem. Quick decision, wrong action.
State your problem.
You should not need to change the CCSID on the qmgrs.
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jjanki |
| Posted: Mon Jun 26, 2006 3:45 am Post subject: |
|
|
Newbie
Joined: 26 May 2006
Posts: 6
|
DB2 version 8 requires the CCSID of MQ to be 37. DB2 version 8 cannot handle CCSID 500 .
So you are saying there should not be a need to flip to 37 even though DB2 V8 requests this. |
|
| Back to top |
|
|
| Glen Shubert |
| Posted: Mon Jun 26, 2006 11:55 am Post subject: |
|
|
Apprentice
Joined: 16 May 2001
Posts: 42
Location: TSYS - Columbus, GA
|
We converted all of our queue managers to 037 from 500 a couple years ago, due to special character support, ie. british pound sign, cent sign, etc. There were no issues for any of our applications.
_________________
Glen Shubert
Associate Director
MQSeries Technical Support
TSYS |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Jun 26, 2006 2:57 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| jjanki wrote: |
DB2 version 8 requires the CCSID of MQ to be 37. DB2 version 8 cannot handle CCSID 500 .
So you are saying there should not be a need to flip to 37 even though DB2 V8 requests this. |
Do you have a statement from IBM saying that DB2 V8 cannot handle CCSID 500 ??
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| tleichen |
| Posted: Thu Jul 06, 2006 6:09 am Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
We always used CCSID 37 on all mainframe queue managers and have not run into any conversion issues.
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
|
|
