MQSeries.net :: View topic - Code page conversion problem 850

narendra

Env: one Win 2k server with MQSeries 5.2.1 with CSD5, WMQI 2.1 CSD4, hardware 1.3 Gz, 1.5 G Ram and plenty of hardisk

DB2 ver 7 with fixpack WR21254 (FP3)

problem desscription:

I have a pub/sub msg flow which consists of ADDRFH2 and compute node

I have a MQ Java client pgm to set the input msg MQMD on the input queue (defined by the MQInput Node)
with message.characterSet = 1208 (ccsid=1208 or UTF-

message.encoding = 546

In the compute node, I use the passthru statement to pass a select statememt to a DB2 database on an AIX server.
The DB2 database on AIX server has code page=850
The output msg delivered to the output queue has correct ccsid = 1208 and encoding = 546 but the conversion of data does not
take place from 850 -> 1208 as expected

This is the DB2 select query on the DB2 AIX server
db2 "select trade_style_name, hex(trade_style_name)

and the result is :

SCORT EspaÃ±Â¤a, S.A.Ã‡
53434F52542045737061A4CF612C20532E412E80

This is the result viewed from the output queue after MQSI (on Win 2k server) pulls from the db2 db on AIX server and delivered to the queue (on the same Win 2k server) with ccsid=1208 and encoding=546

4E 42 52 3E 3C 54 52 41 NBR><TRA
44 45 5F 53 54 59 4C 45 DE_STYLE
5F 4E 41 4D 45 3E 53 43 _NAME>SC
4F 52 54 20 45 73 70 61 ORT Espa
A4 7F 61 2C 20 53 2E 41 Â¤.a, S.A
2E 80 3C 2F 54 52 41 44 ..</TRAD
45 5F 53 54 59 4C 45 5F E_STYLE_
4E 41 4D 45 3E 3C 41 44 NAME><AD

CF (from ccisd=850) should convert to C2A4 (ccsid=1208) but instead it converts to 7F
80 (from ccisd=850) should convert to c387 (ccisd=1208) but instead it remains the same

Thanks in Advance
Narendra