Defining Relationships
A read schema can contain a combination of delimited file records or positional file records. You can create file records and define relationships among them.
When you create the first file record for a read schema, and then create additional records for the same read schema, these records form a relationship automatically. The relationship depends on how you create file records. The first file record created in a read schema is referred to as the root record. A read schema has only one root record. All the other records created after the first file record are referred to as child records.
A root record can have many child records, and each child record can further have child records. The child file records defined immediately under the root record have a Position From Header attribute. With this attribute, the immediate children of the root record in the actual data file are displayed before or after the root record.
Order Customer Item
Order Customer Item Item Order Customer Item
Customer Item Item Order Customer Item Order
The Position from Header attribute set for the child records is either Begin or End, and it cannot be in combination. For example, you cannot set Begin for the Customer file record and End for the Item file record.