MQ message header to Column

lkganta · Post by **lkganta** » Mon Feb 25, 2013 1:50 pm

Hi,
we have MQ read stage in datastage 8.1Px reading the data and passing to next stage with one column-A output. This works fine.

Now, we would like to capture header of each message that comes in MQ to column-B along with column-A. Could you please tell me how to do this?
Any MQ properties setting to be done to get header message information?

Appreciate your qucik response in this.

Thank you
LK

eostic · Post by **eostic** » Mon Feb 25, 2013 4:45 pm

Look in the documentation, and then the Stage or Connector for all of the various "Data Element" options that you have. There are a whole set of them for gathering bits and pieces of the MQ header. I can't remember exactly what it is and am not looking at DataStage right now, but assuming that you are using the MQ Connector with an output link I think one of them is WSMQ.MSGID. That will populate that particular column with the message id.

Ernie