How can I control the processing order of child records ?

How can I control the processing order of child records ?

book

Article ID: KB0090777

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Files for Unix and Windows -
Not Applicable -

Description

Resolution:
"adfiles.toggleChildRecordsOrdering" property in the ".tra" can be used to control the processing order of child records. Without this property file adapter processes the child records in no particular order. Valid values for this property are ON and OFF.

Consider the following scenario. Lets say we have a parent record Order with two child records Item and Customer and our actual
input look something like this:
Order
- Item 1
- Item 2
- Item 3
- Customer 1
- Customer 2

toggleChildRecordsOrdering determines whether all the Item records are to be written before all the Customer records or all the Customer records are to be written before all the Item records.  In other words, depending on the setting of 'toggleChildRecordsOrdering', the output may be :

Order
   Customer 1
   Customer 2
   Item 1
   Item 2
   Item 3

    OR

Order
  Item 1
  Item 2
  Item 3
  Customer 1
  Customer 2


However, 'toggleChildRecordsOrdering' has absolutely no effect on the order of the records within the same child record. In other words,
toggleChildRecordsOrdering does not toggle
Item 1
Item 2
Item 3

to be
                                      
Item 3
Item 2
Item 1

Issue/Introduction

How can I control the processing order of child records ?