| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Correlation problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| ferloz |
 Posted: Thu Jun 23, 2005 12:52 am Post subject: Correlation problem |
 |
|
Novice
Joined: 26 May 2005
Posts: 23
|
Hi all,
i've a problem with CorrelId and a DB2 field .
I'm trying to store the MsgId in a DB2 table for a later use ( see the statement below )
insert into Database.OWMV0PUI.MVIACLIDATA (MVCD_MSGID, ......)
values (InputRoot.MQMD.MsgId, ...... )
When in another msgflow i receiving the answer to the message sent before, i try to correlate
it retireving data from the table filled before with the following ESQL :
set Environment.Variables.User.CorrelId = InputRoot.Properties.ReplyIdentifier;
Set OutputLocalEnvironment.Variables.User.CliData = the(
select t from Database.OWMV0PUI.MVIACLIDATA as t
where t.MVCD_MSGID = Environment.Variables.User.CorrelId );
The column MVCD_MSGID is defined as char 32 .
Where i'm wrong ?
Can somebody help me ?
_________________
fkid |
|
| Back to top |
|
 |
| Ramphart |
| Posted: Thu Jun 23, 2005 3:26 am Post subject: Re: Correlation problem |
|
|
Disciple
Joined: 21 Jul 2004
Posts: 150
Location: South Africa, JHB
|
| ferloz wrote: |
The column MVCD_MSGID is defined as char 32 .
|
You message and correlation ID is 48 long.
It typically lihe this X'414d5120434c565833362e4c4956452ebc51ba4220001501'.
- Make your DB2 field 48 char
- When you log or compare Msg ID do SUBSTRING(Cast(Root.MQMD.GroupId AS CHAR) FROM 3 FOR 48
- When you compare CorrlId use SUBSTRING(Cast(Root.MQMD.CorrelId AS CHAR) FROM 3 FOR 48
_________________
Applications Architect |
|
| Back to top |
|
|
| waugh |
| Posted: Thu Jun 23, 2005 4:45 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 225
|
| FIELD TYPE BLOB SIZE 24 BYTES SHOULD WORK, this is on WINDOWS/UNIX+DB2 |
|
| Back to top |
|
|
| ferloz |
| Posted: Thu Jun 23, 2005 4:54 am Post subject: |
|
|
Novice
Joined: 26 May 2005
Posts: 23
|
Thanks for the suggestions to all.
i'll try them immediatly. 
Paolo
_________________
fkid |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
