| Author |
Message
|
| blane99 |
 Posted: Thu Aug 07, 2003 8:38 am Post subject: data conversion |
 |
|
Apprentice
Joined: 12 Jun 2002
Posts: 41
|
We have a problem with data conversion from a clients os/390 CCSID 500 to sun CCSID 819. The client cannot change their CCSID so they have convert yes on their sdr channel. Format is set to MQFMT_STRING. Some characters are not being converted correctly (like !). Our developers are using JMS. I have 2 questions:
1. Besides an exit what else can be done ?
2. Does JMS have the functionality for GET with convert?
Any help much appreciated
Bob |
|
| Back to top |
|
 |
| PeterPotkay |
| Posted: Thu Aug 07, 2003 6:02 pm Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
The real solution would be to set the os/390 CCSID to 037 (international EBCIDIC) instead of 500 (US EBCIDIC).
Another option is to figure out what character on the mainframe would get converted to !, and then use that instead of the ! on the PUT. (Ugly, but possible).
Another option is to tell the apps to not use the "!". A cop-out, but a solution.
JMS does support convert on GET. We send messages from the mainframe to JMS apps all the time. WITHOUT convert turned on for the channels.
The Convert Option should not be used on the channels. It is leftover from early MQ days when the possability existed of the receiving queue manager not supporting conversion, thus requiring the message to be converted before sending it. Nowadays all QMs will allow their apps to convert, which means there is no need for the overhead of channels doing the converts.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| blane99 |
| Posted: Fri Aug 08, 2003 5:13 am Post subject: data conversion |
|
|
Apprentice
Joined: 12 Jun 2002
Posts: 41
|
Peter
Thanks very much for feedback. Unfortunately, the other qmgr is a vendor who has many other channels to clients like us and they will not cahnge their CCSID nor change the content of their message.
Bob |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Fri Aug 08, 2003 5:16 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
you're stuck with the exit solution 
we had the "!" issue a while back. Eventually we will switch to 037. Luckily, the app was accomadating in our case and was able to substitute some other character for the "!".
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| blane99 |
| Posted: Fri Aug 08, 2003 7:15 am Post subject: data conversion |
|
|
Apprentice
Joined: 12 Jun 2002
Posts: 41
|
Peter
Could I simply change the CCSID on the sun qmgr to be 500 to match the mframe and be done with it? There are no other apps on the sun side.
Bob |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Fri Aug 08, 2003 7:20 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
500 is an EBCIDIC code page, and I would bet that your SUN app is expecting the data in an ASCII set.
So no, that won't work. The sun app would barf on all that EBCIDIC data. At the hexedecimal level, it would be completly wrong.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| blane99 |
| Posted: Fri Aug 08, 2003 7:22 am Post subject: data conversion |
|
|
Apprentice
Joined: 12 Jun 2002
Posts: 41
|
|
| Back to top |
|
|
|
|
