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 ?