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.  create multiple output files per max transaction

    Posted 09/03/09 07:24 PM

    Originally posted by: SystemAdmin


    I need to create an output files for every 100 records. Basically i have to break the output files per 100 records, how do I passed the header and trailer records to each output files? Is there an easy way to doing this?

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


  • 2.  Re: create multiple output files per max transaction

    Posted 09/04/09 05:04 PM

    Originally posted by: SystemAdmin


    The first step is to describe the data. Create a type tree that describes the input file. In this type tree the detail records belong to a group and have a range from 0:100. There are multiple occurences of this detail groups. It looks like this:

    INPUT
    -file
    --header 1:1
    --detail group 1:s
    --- detail record 1:100
    --trailer

    The create another type tree that describes the output file as having a header, 100 details and a trailer. This file belongs to a group and has a range of many.
    It looks like this:

    OUTPUT
    -file 1:s
    -- header
    -- detail record 1:100
    -- trailer

    Create a functional map for the rule that belongs to file. In it put the header, detail group and trailer.
    Such as f_make_file( header_in, detailGroup_in, trailer_in)

    Does this make sense?
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender