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.  How can I use REJECT function?

    Posted 04/20/07 02:24 AM

    Originally posted by: SystemAdmin


    Hi folks,

    I'm working on invalid error handling with WTXv8.1 now.
    Although I looked around this forum and product documentations, I'm still not sure about how the combination of restart and reject works.
    I believe a simple sample, hopefully .mmt and .mtt, would be enough.
    I would appreciate it if someone could give me advice.

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


  • 2.  Re: How can I use REJECT function?

    Posted 04/20/07 05:06 AM

    Originally posted by: janhess


    [b]Using the REJECT Function[/b]

    To map invalid data, you can use the REJECT function. The REJECT function is used in conjunction with the Restart attribute. The REJECT function operates on an invalid data object contained within a valid object. The output of the REJECT function is a series of text items.
    The syntax of the REJECT function is the following:

    REJECT (component_with_the_restart_attribute)

    Use the REJECT function in conjunction with expressions that map valid data. For example, you can generate an error report which contains the invalid input data, in addition to the valid company name and date from the input.
    To map the invalid data objects to an error report, assign the Restart attribute on the component in the Type Designer to map the invalid objects.
    Define the output error report in a type tree. Define the error report to begin with a simple heading, and after the heading, map the invalid objects as text items. The invalid objects must be defined as text items because the output of the REJECT function is a series of text items. Each invalid PO will be considered a stream of text.

    Copyright © 2003 by Mercator Software, Inc.

    [b]How the Restart Attribute Works[/b]

    The restart attribute has the following properties:

    ¨ During validation, the restart attribute is used to tell the system where to start over when an unidentified foreign object (UFO) is encountered in the data. All unrecognized data is considered to be an error of the type with the restart assigned.

    ¨ The restart attribute is used during validation to mark both UFOs and existing data objects in error, which are ignored when mapping input to output.

    ¨ The restart attribute is used to identify valid data objects that contain objects in error.

    If an invalid data object is a component that does not have the restart attribute, that component is marked in error. If components, from the beginning of the data are marked in error because none of them has a restart, the system stops after validation. It does not map the input data to the output.

    Copyright © 2003 by Mercator Software, Inc.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 3.  Re: How can I use REJECT function?

    Posted 04/23/07 05:38 AM

    Originally posted by: SystemAdmin


    Thanx for your info. It was very helpful.

    Do you know some practical cases where REJECT function can contribute?
    For example, because I'm still not sure about how invalid records are evaluated by REJECT fuction, I'm worring about the effect of this evaluation on valid data.
    With this kind of uncertainty, we cannot count on the evaluation by REJECT.
    What do you think?

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


  • 4.  Re: How can I use REJECT function?

    Posted 04/23/07 06:40 AM

    Originally posted by: janhess


    I've never had a problem. Try testing it on your data.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 5.  Re: How can I use REJECT function?

    Posted 04/24/07 02:47 AM

    Originally posted by: SystemAdmin


    'I've never had a problem.'

    No problem?
    How did you test it and can you trust the evaluation by REJECT function?
    What I'm thinking is that it might be impossible to test whole invalid data patterns.

    Anyway, thanks for your post. I'll work around that.

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


  • 6.  Re: How can I use REJECT function?

    Posted 04/24/07 03:41 AM

    Originally posted by: SystemAdmin


    I'm not sure if this kind of situation is practical, but is it possible to extract invalid records without processing valid records?
    How can I cope with the situation requiring only invalid records?
    In other words, does REJECT function work without 'restart' attribute?

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


  • 7.  Re: How can I use REJECT function?

    Posted 04/24/07 04:43 AM

    Originally posted by: deepthideeps


    No..REJECT function works only with RESTART attribute.

    Without RESTART attribute,map stops execution saying "input invalid" for the first invalid record.

    I'm not getting one point.If you require only invalid records,what is the problem in using RESTART attribute and REJECT function??

    Thanks,
    Deepthi
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 8.  Re: How can I use REJECT function?

    Posted 04/24/07 06:02 AM

    Originally posted by: SystemAdmin


    "what is the problem in using RESTART attribute and REJECT function??"

    There's no specific purpose and it was just one of my technical interests.
    Sorry for confusion.

    Thanks for your help.

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