MQSeries.net :: View topic - Create mq-msg from BLOB in DB

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 » Create mq-msg from BLOB in DB

Create mq-msg from BLOB in DB

« View previous topic :: View next topic »

Author

Message

m.schneider

Posted: Thu Apr 03, 2008 1:42 am Post subject: Create mq-msg from BLOB in DB

Centurion

Joined: 10 Apr 2007
Posts: 132
Location: Germany

Hi,

I'm storing a message as a blob in my database.

Code:

DECLARE propRef REFERENCE TO InputRoot.Properties;
DECLARE msgBitStream BLOB ASBITSTREAM(InputRoot.MRM ,propRef.Encoding, propRef.CodedCharSetId, propRef.MessageSet, propRef.MessageType, propRef.MessageFormat);

1. How can I retrieve the message and create a new MQ-Message?
Something like

Code:

SET OutputRoot.MRM = CAST(msgBitStream AS CHAR CCSID InputRoot.MQMD.CodedCharSetId);

2. How can I retrieve the data from MS-Access?

Thanks for your reply.

jefflowrey

Posted: Thu Apr 03, 2008 1:54 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Lots of times this same question is asked and answered.
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Create mq-msg from BLOB in DB

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