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.  UTF-8 to EBCDIC conversion of xml

    Posted 07/22/10 04:25 PM

    Originally posted by: goodboy18


    how should i convert from UTF-8 to EBCDIC. since my input xml is in UTF-8 and i need the output XML in EBCDIC.can someone help me with this?are there any settings in the map that can be changed.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: UTF-8 to EBCDIC conversion of xml

    Posted 07/23/10 02:55 AM

    Originally posted by: SystemAdmin


    you define the character sets in the type tree. E.g. for the output tree, select the field you want to change and amend the "Data language" to one of the EBCDIC character sets.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 3.  Re: UTF-8 to EBCDIC conversion of xml

    Posted 07/24/10 07:29 PM

    Originally posted by: goodboy18


    i have the input,output xsd from which i have created a input,output type tree.currently it has all the fields data language as UTF-8 .so for the fields that i need them in my map generated output xml you want me to covert the datalanguage of these fields as EBCDIC(this applies only to output type tree since i am planning to convert from UTF-8 to EBCDIC). so that the generated xml will have them as EBCDIC.Is my understanding correct.

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


  • 4.  Re: UTF-8 to EBCDIC conversion of xml

    Posted 07/26/10 04:16 AM

    Originally posted by: SystemAdmin


    yes your understanding is correct. To speed up the process you can change the parent type and then propagate the setting down to the child types.
    After changing the language, right-click on "Data language" and select propagate.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 5.  Re: UTF-8 to EBCDIC conversion of xml

    Posted 07/29/10 06:03 PM

    Originally posted by: goodboy18


    i do have to do a EBCDIC to ISO8859-1/UTF-8 conversion on the response.do i need to use any conversion functions that are present in the WTX .since by just marking the datalanguage of INPUT xsd to EBCDIC,and OUTPUT xsd to UTF-8 i am not getting the correct format of the data.the fields that are displayed in the output are not human readable.any thoughts on this?

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


  • 6.  Re: UTF-8 to EBCDIC conversion of xml

    Posted 07/29/10 06:05 PM

    Originally posted by: goodboy18


    also can you let me know what is the correct EBCDIC code that i need to select for USA.since i am using WTX8.2 i have EBCDIC as deprecated.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 7.  Re: UTF-8 to EBCDIC conversion of xml

    Posted 07/30/10 03:53 AM

    Originally posted by: SystemAdmin


    ISO8859-1 and UTF-8 are not the same - which do you want?

    Only you know the format of your data - you'll need to work out the right character set based on the source application and OS.
    Post your maps and data to the forum and I'll have a quick look, but you're more likely to be successful if you speak to your application team.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 8.  Re: UTF-8 to EBCDIC conversion of xml

    Posted 08/27/10 03:36 AM

    Originally posted by: SystemAdmin


    Hi Oliver,

    I have the same scenario of converting the UTF-8 to EBCDIC,but since my input UTF-8 contains the japans characters when i try to convert it into EBCDIC ,the output truncates the japans character and fails at target side when i set the output type tree properties as Bytes and when i use as character it will was successful,i guess their is some bug in wtx8.2 if my understanding is correct ?
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender