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.  Release Character for Input

    Posted 09/15/08 12:40 PM

    Originally posted by: SystemAdmin


    I've tried reading the documentation, and experimented with the type tree, but I haven't been able to configure a release character for apostrophes on input.

    I'd like to apply a second apostrophe as a release to an input group, so that all fields in the input record have the release character applied. I'm pulling the individual fields apart to create a call to an Oracle stored procedure, and I'd prefer not to have to do a SUBSTITUTE on each field. The call to the stored procedure requires the apostrophes be used around each field, and the only way I've figured out how to maintain an apostrophe in the data is to use two of them together.

    For example ... input record is comma delimited:
    John, O'Malley, 150.00, 3, Widgets

    I need to build the statement to be:
    "call ORDER.INSERT_RECORD('John', 'O''Malley', '150.00', '3', 'Widgets')"

    Please let me know if I can do this on the input side? Thanks.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Release Character for Input

    Posted 09/17/08 04:56 PM

    Originally posted by: SystemAdmin


    I'm close. I defined a Syntax Item, called myChars2Release. In the restriction list, I added the apostrophe. Then, on the output group, I changed the Type Syntax -> Release to Variable. Under Release, Default = ', Item = myChars2Release, and Find = Yes.

    Problem #1:
    This seems to work ok if the only item in the data that I want to apply my release character to is an apostrophe. But if I add more characters, say @ or & to the restriction list, the release character is not applied.

    Problem #2:
    My setup only works if the Type Syntax -> Release -> Default value is the same as the item I want to release. What if my release character is / and the 'syntax item' that I need to apply the release character to is #? I can't get the tree to analyze without errors, because I would need to set the Default to / and the restriction list to #. Then I get "Default RELEASE CHARACTER not in restriction list" error from the type tree analyzer.

    Anyone? I'll try most any suggestion, and post my results for all.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


Related Content