How to covert EBCDIC format to ASCII in JMS Adapter??????????

[madhusudana_reddy2]

Hi All,

I am developing one JMS to File scenario, in which JMS adapter will pick file which is in EBCDIC format from WebSphere MQ and send it to receiver file system by receiver file adapter. when i am trying this, i am getting file in EBCDIC format in receiver file system, but the file system is expecting data in ASCII format.

Is there any options to encode the EBCDIC format to ASCII in Sender JMS Adapter or Receiver File Adapter.

Thanks,

Madhusudhan.

[Former Member]

Madhusudhan,

In the Communication Channel parameters for the JMS connection to MQ Series, there is a field "Character Set ID (CCSID) of Destination". In our system this is set to 819 on sender channels and 1047 on receiver channels.

This was set up 2 years ago and has been working fine since.

I think there may have been some issues with availability of the relevant CCSID on the Solaris server - Unix admins may have needed to install / configure.

Andrew

[madhusudana_reddy2]

Hi,

Thanks for your reply. I changed the CCSID setting in Sender JMS adapter to 819 as mentioned by you and in the receiver file adapter encoding to ASCII, but still it is not working.

Can you please tell us how to check the availability of 819 CCSID in Windows server. We are not getting any error in Sender Communication Channel for code conversion.

Regards

Madhusudhan.

[Former Member]

Hi,

It was Basis / Database / OS staff that configured this aspect of the connection, and I am afraid I do not have any more details.

A Google search gave me the following from IBM Documentation on MQ Series:

<a href="http://publib.boulder.ibm.com/infocenter/wsphelp/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/ucli_pqcfm.html">http://publib.boulder.ibm.com/infocenter/wsphelp/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/ucli_pqcfm.html</a>

<b>MQSeries queue connection factory settings for application clients</b>

CCSID

The coded character set identifier for use with the WebSphere MQ queue manager.

This coded character set identifier (CCSID) must be one of the CCSIDs supported by WebSphere MQ.

Data type String

For more information about supported CCSIDs, and about converting between message data from one coded character set to another, see the WebSphere MQ System Administration and the WebSphere MQ Application Programming Reference books. These are available from the WebSphere MQ messaging multiplatform and platform-specific books Web pages; for example, at <a href="http://www-3.ibm.com/software/ts/mqseries/library/manualsa/manuals/platspecific.html">http://www-3.ibm.com/software/ts/mqseries/library/manualsa/manuals/platspecific.html</a> , the IBM Publications Center , or from the WebSphere MQ collection kit, SK2T-0730.

hope this may be of some help

Andrew

[Former Member]

Have used JMS to connect to MQ series - As long as JMS adapter is configured with correct code page when connecting to MQ series, data in XI is received as / converted to ASCII.

Andrew

[madhusudana_reddy2]

Dear andrew,

how to be configure sender jms adapter to codepage of ebcdic

[Former Member]

Hi !

(Refer SAP Help http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/frameset.htm)

SAP Note 859548 may be able to help you. More info is available on SAP Help at this location:

http://help.sap.com/saphelp_nw04/helpdata/en/c1/739c4186c2a409e10000000a155106/frameset.htm

http://en.wikipedia.org/wiki/ASCII

http://help.sap.com/saphelp_nw2004s/helpdata/en/c1/739c4186c2a409e10000000a155106/content.htm

Regards

Abhishek Agrahari

[Former Member]

Hey

in receiver File adapter try giving encoding as US-ASCII

Thanx

Aamir

Message was edited by:

Aamir Suhail