IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
 View Only
Expand all | Collapse all

Reading MQMD for group message in ITX 9.0

  • 1.  Reading MQMD for group message in ITX 9.0

    Posted Tue October 29, 2019 04:44 AM

    Originally posted by: PSAK


    Hi,

    I am trying to read Group messages from an IBM MQ Queue through ITX MQ Client Adapter using -GRP2 command and its working.

    -QMN QM1 -QN TEST -CD TEST.SVRCONN/TCP/127.0.0.1(1414) -HDR -GRP2 -REFRESH 60

    However, I could see MQMD attached to each logical messages in the group.

    As I need at read first occurrence of MQMD for my processing, how can we achieve fetch message without multiple headers ? If not possible in command, how can we handle it in typetree?


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: Reading MQMD for group message in ITX 9.0

    Posted Mon November 04, 2019 04:22 AM

    Originally posted by: PaulBrett


    On the output side, a modified version of the standard mq.mtt Typetree can be used to read the messages, with only the 'Data' object being a repeating group.  Populate the header bit from the input side (with the header part of the output NOT being a repeating group, you will only get one occurrence) and then group to a functional map to map all the data parts.

    Input             Output

      Message(s)        Message

        Header           Header

        Data             Data(s)   (=F_EachInMsg(Message:Input)

    I hope this is clear

    Thank you.

    Paul

    Follow me on Twitter


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender