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.  Invalid XML question

    Posted 08/02/10 06:11 AM

    Originally posted by: SystemAdmin


    I'm working with a CICS system that in certain (limited) scenarios, returns a utf-8 XML message that contains NULL characters (U+0000) within an XML element

    ie

    <SomeElementOrOther>U+0000 U+0000 U+0000</SomeElementOrOther>

    The XML parser (Datapower) receiving this doesn't recognise this as valid XML and throws an exception.

    Fixing the CICS system will take some time so given that I've an XML schema for the message I'm hoping that I can create a WTX validation map to remove the NULLs, giving an output <SomeElementOrOther/>

    As the message already routes through datapower this is where I would execute the map.

    I'm not yet in a situation to reproduce the problem and am a WTX novice so thought I'd ask if creating this sort of data cleansing map using WTX is straightforward or am I missing something obvious?

    I'd use the same type tree for input and output cards, and envisage that I'd have to configure the map to continue on an error in the validation stage. Also, in the infocenter I see there is an option to remove whitespace, but I guess this isn't really whitespace as such so any tips on how to remove the NULLS is appreciated.

    Thanks

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