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.