Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
No new posts comparing comp-3 and unpacked numbers juares castro COBOL Programming 3 Mon May 30, 2016 6:46 pm
No new posts Need help on comparing hexadecimal va... ashok_uddaraju DFSORT/ICETOOL 4 Thu Apr 28, 2016 2:08 am
No new posts Comparing two VB files phani_nittice SYNCSORT 8 Fri Jan 22, 2016 1:19 am
No new posts Comparing timestamp in Synscort l.nethaji SYNCSORT 13 Wed Jan 20, 2016 4:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us