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.  XML to cobol mapping

    Posted 08/11/08 04:25 AM

    Originally posted by: Rajeev30


    Hi,

    I am trying to map XML to copybook in WTX. But I am facing encoding issue. When ever i convert my xml to Cobol My out put is like this

    扄‡…£@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@Ñ–ˆ•@Ä–…@@@@@@@@@@@@@@@@@@@@@@ñòó@Õ–™£ˆ@â£@@@@@@@@@@@@@@@@@@Ô‰�”‰@@@@@@@@@@@@@@@@@@@@@@@@@ÆÓ@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    and when i convert my cobol to xml My output is like this

    <purchaseOrder>
    <item>ïÑÀÅÁȀ€€€€€€€€€€€€€€€€€€€€€€€</item>
    <item_count></item_count>
    <shipTo>
    <name>¢?Ç>€à?Á€€€€€€€€€€€€€€€€€€€€€€</name>
    <street>‘“€+?ÊÈǀëȀ€€€€€€€€€€€€€€€€€</street>
    <city>(Ñ/_р€€€€€€€€€€€€€€€€€€€€€€€€</city>
    <state></state>
    <zip></zip>
    </shipTo>
    </purchaseOrder>
    for creating copybook tree I have used Character set EBCDIC and Byte order BIG ENDIAN. I also tried saving XML in UTF-8 format also but it didn't worked.Can you please let me know what mistake I am doing.

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


  • 2.  Re: XML to cobol mapping

    Posted 08/11/08 04:35 AM

    Originally posted by: janhess


    If you view it in EBCDIC it looks right apart from one field - City I think.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 3.  Re: XML to cobol mapping

    Posted 08/12/08 02:56 AM

    Originally posted by: Rajeev30


    Hi,

    what encoding sytle i need to set in my input and output tree for xml to cobol mapping.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 4.  Re: XML to cobol mapping

    Posted 08/12/08 06:23 AM

    Originally posted by: janhess


    What you are already using if you want EBCDIC output.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 5.  Re: XML to cobol mapping

    Posted 08/12/08 10:12 PM
      |   view attached

    Originally posted by: Rajeev30


    Hi,
    thanks for you input, I have solved this encoding issue. Another issue which i am facing is how to map iterative elements in WTX for example my request xml is attached, it contains
    .......
    <searchArray>
    <lookupValue>SHOWALL</lookupValue>
    <lookupType>11</lookupType>
    </searchArray>
    <searchArray>
    <lookupValue>SHOWALL</lookupValue>
    <lookupType>11</lookupType>
    </searchArray>
    .....

    Now if I have to map this to my cpy tree. Is there any special technique for mapping such element as in my output map iteratived elemets are all grey shaded so i can't add any rule to them .Hope you are getting my point.
    I am attaching my cpy and XSD also
    Regards
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender

    Attachment(s)



  • 6.  Re: XML to cobol mapping

    Posted 08/13/08 04:37 AM

    Originally posted by: janhess


    Use a functional map in the occuring field in the output card passing the required data as parameters. Use the functional map wizzard to create the functional map.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender