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.  Search and Replace

    Posted 07/20/10 08:17 AM

    Originally posted by: SystemAdmin


    Why is Search and replace in type tree not working in 8.2 version.It worked fine in the 8.1 of WTX. Is there a work around. I need to change lot of <CR>LF> to <NL> in the trees.

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


  • 2.  Re: Search and Replace

    Posted 07/26/10 06:34 AM

    Originally posted by: thorstenhirsch


    Are you running WTX on Windows now? There, <CR><LF> is the same as <NL>. Actually <NL> can mean different things, depending on your platform:

    • Windows -> <NL> == <CR><LF>
    • Linux/Unix -> <NL> == <LF>

    So if you want to make sure what you're replacing and if you want WTX to be platform independent (meaning that the mapping should do the same on all platforms), you should never youse <NL> in your output, but always specify if you mean <CR><LF> or <LF>.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Search and Replace

    Posted 07/26/10 03:04 PM

    Originally posted by: SystemAdmin


    "you should never youse <NL> in your output, but always specify if you mean <CR><LF> or <LF>."

    That is the point of the <NL>, so you can use this symbol to be platform independent (most commonly used as terminator type syntax for a record (group)). Since <NL> is translated based on platform you do not have to change <CR><LF> to <LF> when moving from windows to unix for instance, the <NL> will work on both platforms.

    Ofcourse there are times that you want to use "<CR><LF>" specifically, so you can't always assume <NL> is the way to define things, that will be determined by your implementation. For instance, DBQUERY will use <CR><LF> to terminate the results returned from the functional call whether on windows or unix.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 4.  Re: Search and Replace

    Posted 07/26/10 04:30 PM

    Originally posted by: SystemAdmin


    Try making your change at the group or category level in the type tree. Select the group or category. Right click and select properties. Make your change. Then right click in the properties window on the the object or parent of the object you which modify for all children in that sub-tree. Select Propagate.

    And, yes, you normally want your record/segment/row terminators to be NLs unless you have some specific reason otherwise. Then WTX will modify the terminators as required by the target system.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender