MQSeries.net :: View topic - ESQL : OutputRoot showing NULL values

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 » ESQL : OutputRoot showing NULL values

ESQL : OutputRoot showing NULL values

« View previous topic :: View next topic »

Author

Message

hellobond070

Posted: Fri Mar 05, 2010 2:56 am Post subject: ESQL : OutputRoot showing NULL values

Centurion

Joined: 18 Nov 2009
Posts: 118

Hi All,

I have the below code which is not working correctly. I see the enviroment tree getting populated correctly but the blobDataStr is not having any data. What must be wrong. Any suggestions.

Code:

SET Environment.Variables.IDOC = InputRoot.IDOC;
DECLARE blobDataStr BLOB;
SET blobDataStr = ASBITSTREAM(Environment.Variables);
SET OutputRoot.DataObject.ns:SapXXXX01.IDocStreamData = blobDataStr;

mqjeff

Posted: Fri Mar 05, 2010 3:08 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

The Environment tree has no parser that knows how to serialize it's elements.

hellobond070

Posted: Fri Mar 05, 2010 5:48 am Post subject:

Centurion

Joined: 18 Nov 2009
Posts: 118

But the below code throws an error at 2nd statement. What is the way out to convert the whole InputRoot.IDOC to Blob without error

Code:

DECLARE blobDataStr BLOB;
SET blobDataStr = ASBITSTREAM(InputRoot.IDOC);
SET OutputRoot.DataObject.ns:SapXXXX01.IDocStreamData = blobDataStr;

Gaya3

Posted: Fri Mar 05, 2010 6:11 am Post subject:

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

http://www.mqseries.net/phpBB2/viewtopic.php?t=39889&highlight=mrm+blob

http://www.mqseries.net/phpBB2/viewtopic.php?t=40139&highlight=mrm+blob

http://www.mqseries.net/phpBB2/viewtopic.php?t=40226&highlight=mrm+blob

http://www.mqseries.net/phpBB2/viewtopic.php?t=40689&highlight=mrm+blob

there are lot more...search it, but i am sure you will learn from all these...and write a nice code...
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL : OutputRoot showing NULL values

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