MQSeries.net :: View topic - Can CorrelId value be changed using ESQL

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 » Can CorrelId value be changed using ESQL

Can CorrelId value be changed using ESQL

« View previous topic :: View next topic »

Author

Message

Scorpio_16

Posted: Thu Nov 05, 2009 7:36 am Post subject: Can CorrelId value be changed using ESQL

Apprentice

Joined: 15 Dec 2008
Posts: 25

Hi

Can we change the CorrelId Value in a compute node in Message Broker V6.1 ?

I have a simple piece of code which edits the correlId value as shown below

Code:

SET Environment.Variables.Order.Create[] = (SELECT A.CORREL_ID FROM Database.WORKTABLE AS A WHERE A.STATUS = 'BUY' );

DECLARE ordercr REFERENCE TO Environment.Variables.Order.Create;

SET OutputRoot.MQMD.CorrelId = ordercr.CORREL_ID ;

RETURN TRUE;

The output which I always get is

CorrelId = X'000000000000000000000000000000000000000000000000' (BLOB)

Any ideas why this is happening ?

Thanks in advance.

D

smdavies99

Posted: Thu Nov 05, 2009 7:59 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Pretty well the exact same question was asked only a few days ago. If you had sone a simple search then you might have found this post.
http://www.mqseries.net/phpBB2/viewtopic.php?t=51409
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Can CorrelId value be changed using ESQL

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