IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
Expand all | Collapse all

WTX(EBCDIC format) in mainframes

  • 1.  WTX(EBCDIC format) in mainframes

    Posted 07/08/08 12:08 PM

    Originally posted by: SystemAdmin


    can any one tell me what need to be changed in MAP /Type Tree to change the Output language in ASCII format to EBCDIC format ?...and also need to remove New Line character ?......Everything i want it in Mainframes ...Please discuss if we have similar issues faced before
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/08/08 12:32 PM

    Originally posted by: SystemAdmin


    Take a look at the Convert function.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 3.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/09/08 01:15 AM

    Originally posted by: SystemAdmin


    Hi,Thanks for your reply...
    I want to display everything in EBCDIC format,Currently what i did for that is I amend the Output Type tree(each and every element)Language to Native and corresponding change in Map was encoding is set to IBM-1047 and Build the map under Z/OS platform and ran the same in Mainframes,Now if i see the Output in Mainframes,its not in expected format(some unknown format is coming)....

    I hope my question is clear now...please discuss if anyone done this before....
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 4.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/09/08 06:17 AM

    Originally posted by: janhess


    My understanding is that if you set language to native (the default) in the type tree it will produce output in the desired format of the OS the map is built for.
    Where are you doing encoding set to IBM-1047?
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 5.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/09/08 10:41 AM

    Originally posted by: SystemAdmin


    we have one attribute like encoding in output type tree,previously we set that to utf-8 now i set to IBM-1047 (encoding = "utf-8" now encoding = "IBM-1047")....is that going to efect that...........If not please give some suggestions....
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 6.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/09/08 10:44 AM

    Originally posted by: janhess


    Have you tried setting it to Native?
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 7.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/09/08 10:57 AM

    Originally posted by: SystemAdmin


    Hi,
    see this
    i used JCL to convert the format to IBM-1047 which is readable in Mainframes side like as given below..

    <?xml version="1.0" encoding="utf-8"?>.<ims:ShowInvoice xmlns:oa="http:

    Now my requirement is that i want this display thru WTX without using the JCL for the same and also i dont need New line character like if you observe the above u can see . between tags (>.<)what i required is >< ......

    Please give me suggestions ASAP.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 8.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/10/08 04:11 AM

    Originally posted by: janhess


    Sorry, I don't understand what you're trying to do. I think you need to give a step by step explanation.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 9.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/10/08 07:45 AM

    Originally posted by: SystemAdmin


    Hi
    What we are doing is..

    We are converting XML format to EIMS format,for that we are using WTX tool...fpr Map we have Input type tree and Output Type Tree ...for the Input type tree Language is set to Native,for output Type Tree every element language is set to UTF-8(depricated) previously so after we ran the Map in windows we get the Output file in UTF-8 format ,in mainframes we were not able to understand the Output(which is not understandable format)for that we need to ftp it to windows and then we used to seeit ,..... now we want to see it directly in Mainframes,for that what iam doing is iam changing the outpu type tree language set to Native and ran the Map but still the output is not understandable....
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 10.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/10/08 07:49 AM

    Originally posted by: janhess


    Is the input on the mainframe readable?
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 11.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/10/08 08:23 AM

    Originally posted by: SystemAdmin


    yes the input to Map is XML file which is readable in mainframes
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 12.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/14/08 03:06 AM

    Originally posted by: SystemAdmin


    Any suggestions on the above issue freinds???
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 13.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/14/08 08:06 AM

    Originally posted by: SystemAdmin


    Instead of Native, try IBM-1047 data language in the output type tree and set the encoding type to IBM-1047 also in the output card.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 14.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/15/08 02:57 PM
      |   view attached

    Originally posted by: SystemAdmin


    Without even taking a minute to thing about what you're asking, attached is a map that does a convert.

    We have process that pushes data to a message queue on a mainframe and is read by DataStage on Unix. The data coming in is EBCDIC and the output is ASCII.

    In the zip file are two reference files; one is EBCIDIC to ASCII, the other is ASCII to EBCDIC. You'll just have to add the input card and reference the type you want to convert in the CONVERT function.

    Hope this helps.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender

    Attachment(s)



  • 15.  Re: WTX(EBCDIC format) in mainframes

    Posted 07/15/08 03:59 PM

    Originally posted by: SystemAdmin


    This appears to be the example conversion map that ships with product and can be found at ..\examples\general\portdata.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange