SQL MQSEND and MQRECEIVE

[mclarenpaul]

I've been experimenting with the MQSEND and MQRECEIVE SQL functions which work really well for sending the body of a message to message queue or receiving the body of a message from a message queue, however for the life of me I cannot see how to set or retrieve the MQMD message header details of the MQ message. I can see that I can set some of these values through the MQ_POLICY that I'm specifying but I can't see anywhere how to retrieve the message header details that you would get when using the traditional MQGET function supplied with the IBM i in QMQM. An example on MQRECEIVE would be to also get the MSGID of the message I've received or the reply to Message Queue, not just the message body.

Has anyone managed to find a way to do this in ILE RPG using the MQSEND and MQRECEIVE SQL functions? I would really like to move away from using /COPY with QMQM.