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

SUBSTITUTE function Not working on z/os

  • 1.  SUBSTITUTE function Not working on z/os

    Posted 05/06/16 06:54 AM

    Originally posted by: AnjaliMKanjinghat


    Hi,

    I am trying to use the below code ,

    =PUT("WIRE","out10",CPACKAGE(  SUBSTITUTE(SingleChunkOut Field:Out,

    "<AccountPostingRequest>","<isfTMH:AccountPostingRequest  xmlns:isfTMH=""http://www.ibm.com/xmlns/prod/ftm/isf/v3/tmh"" xmlns:isf=""http://www.ibm.com/xmlns/prod/ftm/isf/v3"">",

    "</AccountPostingRequest>","</isfTMH:AccountPostingRequest>"),"NATIVE")))

     

    In Windows the SUBSTITUE is working fine and we can see the output as

    <isfTMH:AccountPostingRequest xmlns:isf="http://www.ibm.com/xmlns/prod/ftm/isf/v3" xmlns:isfTMH="http://www.ibm.com/xmlns/prod/ftm/isf/v3/tmh">

     

    But the same code in z/os the output looks like,

    <AccountPostingRequest>

     

    Somehow the SUBSTITUTE is not working.

    Did anyone face this issue.

     

    Thanks in Advance.

     


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


  • 2.  Re: SUBSTITUTE function Not working on z/os

    Posted 05/13/16 05:05 AM

    Originally posted by: paul.brett


    What happens if you try something simple first:

    SUBSTITUTE(SingleChunkOut Field:Out,

    "<AccountPostingRequest>","substituted!!!")

    ....does that work on both platforms?

    Thank-you

    Paul

    Follow me on Twitter


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