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.  Partition Question

    Posted 03/01/04 04:40 AM

    Originally posted by: SystemAdmin


    I am creating a tree (.mtt), part of the tree has contains a variable structure, which can be one of 4 formats. The formats can only be identified by structure and not by value. They look something like

    i:0e0765413a/xx<CR><LF>[/i:0e0765413a]
    or
    i:0e0765413a/xx/yyyyy<CR><LF>[/i:0e0765413a]
    or
    i:0e0765413a/xx/yyyyy/aa/bbb/aa/bb<CR><LF>[/i:0e0765413a] {/aa/bb releapts (s) times}
    or
    i:0e0765413a/xx//aa/bb/aa/bb<CR><LF>[/i:0e0765413a] {/aa/bb releapts (s) times}

    yy, aa and bb have variable size xx is ficed at 2 chars.

    How can I define this ?

    I've been messing around with Partitions but can't seem to get it to work.
    Thanks in advance for any help[/url]
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Partition Question

    Posted 03/01/04 05:32 AM

    Originally posted by: SystemAdmin


    The key to getting this partition to work is component rules. You could also use a choice group to do the same thing.

    [url]http://www.stottcreations.com/nevinsm.mtt[/url]
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: Partition Question

    Posted 03/01/04 06:32 AM

    Originally posted by: SystemAdmin


    Once again there are several ways to do this. I would agree with the earlier post that the easiest way to this may be a combination of CHOICE group and component rules.

    I have a tree that has these groups defined and a map that has seperate functional maps to split them out based on the rules (the four types). It may be easier for me to send you the tree/map than to detail it here (let me know if you want them).

    THe general concept to take from this example is that when you set up your choices you will want to define your hardest to satisfy group first.

    I have a choice group (Pickem) containing groups:
    1. xxyyaabb
    2. xxaabb
    3. xxyy
    4. xx

    The groups are all <NL> terminated and / prefix delimited. Groups xxyyaabb and xxaabb contain a mandatory repeating subgroup aabb which is / infix delimited.

    In order to distinguish between groups xxyyaabb and xxaabb I have them both defined as containing element xx and yy and mandatory repeating group aabb, but in xxaabb the yy component is optional and a component rule specifies ABSENT($). In group xxyyaabb the yy component is mandatory with a PRESENT($) rule on it.

    This should give you a glimpse of one way to define this data. As I said, if you would like the tree and map I was playing with, let me know.
    Cheers!
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 4.  Re: Partition Question

    Posted 03/01/04 07:39 AM

    Originally posted by: SystemAdmin


    [url]http://www.stottcreations.com/nevism.bmp[/url]

    Since this is in 6.5 and I am on 6.7. ABSENT and PRESENT would be a bad choice in the component rules, because in the case of 'xx//aa/bb<CR><LF>, the /yy/ is present there, but the size is 0.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 5.  Re: Partition Question

    Posted 03/02/04 01:12 AM

    Originally posted by: SystemAdmin


    Thanks sfetzer & ericstott,

    with your help I have now resolved the problem

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