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.  One or more inputs invalid issue.

    Posted 01/27/15 05:01 PM

    Originally posted by: mbscott


    Hi,

    I have input type tree(copybook)  with group terminator TAB.

    But source systems sends data either TAB or NONE.

    When data comes without TAB at end of the data, map failing with one ore more inputs invalid.

    Can you please share your thoughts, how to make group terminator to accept either NONE or TAB.

    Thanks in advance.


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


  • 2.  Re: One or more inputs invalid issue.

    Posted 01/28/15 04:17 AM

    Originally posted by: paul.brett


    When you say NONE, do you mean there is no group terminator at all?  The next group follows immediately after, and there is no way to determine that the current group has finished?

    I would say that a human would have difficulty under these circumstances, let alone a computer.

    You will need to find a way to differentiate when a new group is starting.  Perhaps you could pre-process the data, search for the group initiator, attempt to detect if it is preceded by a TAB, and if not, insert one.

    Thank-you.

    Paul.

    Follow me on Twitter


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


  • 3.  Re: One or more inputs invalid issue.

    Posted 01/28/15 08:27 AM

    Originally posted by: mbscott


    Ok. When input has only one group, and end of group with TAB or without TAB(NONE), How do we specify terminator?

    EX: AAAABBBBCCCCTAB

     

            AAAABBBBCCCC


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


  • 4.  Re: One or more inputs invalid issue.

    Posted 01/28/15 11:22 AM

    Originally posted by: paul.brett


    So, your data is:

    AAAABBBBCCCCAAAABBBBCCCC

    ...and there's nothing to tell me where the group ends?  (after the first set of 'CCCC')

    Thank-you.

    Paul.

    Follow me on Twitter


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


  • 5.  Re: One or more inputs invalid issue.

    Posted 01/28/15 11:33 AM


  • 6.  Re: One or more inputs invalid issue.

    Posted 01/28/15 11:41 AM

    Originally posted by: paul.brett


    If there is no identifying mark after the group, how do you know the group has ended?  Does the next section of the message have an initiator?

    Thank-you.

    Paul.

    Follow me on Twitter


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


  • 7.  Re: One or more inputs invalid issue.

    Posted 01/28/15 12:15 PM

    Originally posted by: mbscott


    If there is more than one record. input will be like this

    AAAABBBBCCCCAAAABBBBCCCC

    AAAABBBBCCCCAAAABBBBCCCC

    AAAABBBBCCCCAAAABBBBCCCC


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


  • 8.  Re: One or more inputs invalid issue.

    Posted 01/28/15 12:47 PM

    Originally posted by: paul.brett


    I am thoroughly confused now.  Where do records come into it?  We were talking about groups.

    Based on what I am seeing, I think it is time to raise this as a PMR with IBM Client Support, with a full testcase and description.

    Thank-you.

    Paul.

    Follow me on Twitter


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


  • 9.  Re: One or more inputs invalid issue.

    Posted 01/28/15 02:26 PM

    Originally posted by: mbscott


    sorry. I meant was each row is one group.


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


  • 10.  Re: One or more inputs invalid issue.

    Posted 01/29/15 05:00 AM

    Originally posted by: paul.brett


    So, as well as a TAB, there is also a <NL> after each group?

    I think perhaps you could forget using the tab as a the terminator, and 'consume' the optional TAB character with a new Typetree object as the last component of the group.

    Does that help?

    Thank-you.

    Paul.

    Follow me on Twitter


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