Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Comparing MQ MSG ID and correlation ID

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
SushilZade

New User


Joined: 25 Jun 2010
Posts: 4
Location: Pune

PostPosted: Fri May 23, 2014 5:36 pm    Post subject: Comparing MQ MSG ID and correlation ID
Reply with quote

Hi,

Can someone help me with this. I tried to look for the information supporting the scenario but couldn't find.
Here is the scenario -

When the message is PUT, the MSGID generated is retained with the application in a db2 table A with column of 24 char.
The messages are then accessed cross - platform and Acknoweldgment MQ message is sent back to the originating application with correlation ID same as msg ID.

I am trying to retrieve the record from table A using correlation ID for associated msgid. With an sql for msgid = correlation id; I am not getting any rows.

When I browsed both the queues, I found that the 24 bytes of msg ID and correlation ID are matching.

Thank you.
Back to top
View user's profile Send private message

SushilZade

New User


Joined: 25 Jun 2010
Posts: 4
Location: Pune

PostPosted: Mon May 26, 2014 5:21 pm    Post subject: Reply to: Comparing MQ MSG ID and correlation ID
Reply with quote

Got the solution! Hope this will help someone having similar problem.

MQGMO-CONVERT comes to the rescue. While analysing the program and using Google to its effect; found that MQGMO_CONVERT should always be used with MQGET statement in summing up the MQGMO-OPTIONS.

Code:
COMPUTE MQGMO-OPTIONS           = MQGMO-WAIT
                                + MQGMO-SYNCPOINT
                                + MQGMO-FAIL-IF-QUIESCING
ADD MQGMO-CONVERT              TO MQGMO-OPTIONS.
.
.
Code:
MOVE MQMI-NONE                 TO MQMD-MSGID.
MOVE MQCI-NONE                 TO MQMD-CORRELID.

CALL 'MQGET'                USING MQ-HCONN
                                  MQ-NATIVE-HOBJ
                                  MQMD
                                  MQGMO

.
.

As I observed, MQGMO-CONVERT was missing from the code.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts To get Non matching row after compari... vinu78 DB2 7 Fri Jan 05, 2018 5:43 pm
No new posts Comparing dates in different formats migusd SYNCSORT 4 Sat Nov 18, 2017 3:02 am
This topic is locked: you cannot edit posts or make replies. Comparing current time with the time ... arunsoods SYNCSORT 1 Mon Oct 30, 2017 4:07 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us