MQSeries.net :: View topic - Problem When get data from Database

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem When get data from Database

Problem When get data from Database

« View previous topic :: View next topic »

Author

Message

anhnt

Posted: Wed Aug 06, 2003 3:46 am Post subject: Problem When get data from Database

Acolyte

Joined: 03 Aug 2003
Posts: 54

Hi all,
My problem is:
When I insert Fields of a message into Database(Oracle 9i) with CCSID 1208(UTF-

,no problem.
But When I Query Database.and create Output message with content of fields is received data.Displayed message is incorrect(Contents of message were displayed in VB.NET).although OutputRoot.MQMD.CodedCharSetId is 1208(UTF-

.

Somebody help me to resolve my problem.

Thanks,
anhnt

shalabh1976

Posted: Thu Aug 07, 2003 5:24 am Post subject:

Partisan

Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India

Try using the CREATE with PARSE option in your ESQL.

Suppose you extract your Database record into a variable 'Varch'
Then CREATE Lastchild of OutputRoot DOMAIN 'XML' PARSE(Varch,ENC,1208);

where ENC is your value for 'encoding' eg 546

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem When get data from Database

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP