IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
  • 1.  Commit individual message to Queue instead of global trasaction management

    Posted 03/27/09 05:27 PM

    Originally posted by: muralee


    Currently we are trying split 1000 claims of 837 data and trying to put them onto a Websphere MQ queues.
    and this is the following code using to put message onto queue

    =VALID(PUT("MQS", "-QMN %qmgr% -QN %splitputqn_837i% -TE %audit%" + TCCN:HeaderGroup:HeaderFileGroup MessageHeader:Out + ".mql", TEXT(HeaderFileGroup MessageHeader:Out)),"FAIL|"+"Put to split queue failed(Patient Claims).Error"+LASTERRORMSG())

    The problem what we are facing is that all messages participating onto Global Transaction management i.e
    all individual claims are under a single MQ sync point. What we want
    is that all individual claims processed from a single file must be
    put into a queue before the synch point is released and each individual
    claim can be pushed to the next process.

    Each individual claim must be released to the next process in real time and
    not delayed in a batch process.

    which means that whenever we put a claim onto queue , it has to be strong commit and shd be picked by next process without waitng for rest of the claims also joining that transaction.

    Can anybody tell us how to handle this , would really appreciate if we could be provided some solutions for this.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Commit individual message to Queue instead of global trasaction management

    Posted 03/30/09 02:02 PM

    Originally posted by: raksud


    Iam also facing similar kind of problem ,
    can we really commit individual messages onto queue.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Commit individual message to Queue instead of global trasaction management

    Posted 04/01/09 11:47 AM

    Originally posted by: Yusuf@BOE


    You could try calling a RUN map for each message instead of using PUT. Don't use VALID or you will fail the calling map and your batch.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 4.  Re: Commit individual message to Queue instead of global trasaction management

    Posted 04/01/09 11:59 AM

    Originally posted by: janhess


    Or you could output each message to a unique file name with PUT and have a second map to trigger on the existence of the file to send the message to the queue.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender