File layouts for inserting data in to multiple records

File layouts for inserting data into parent-child records. (File layouts for inserting data in to multiple records).

Define the file layout with the child record as sub-segment. In File layout segment properties define the file record id. A number that should appear as a first column in the input file to identify that it contains the data for its corresponding record.

Since we have more than one record, we need to set this file record id for the both records / segments.

888 – File record id - This record contains only one field and its value is A.

000 – File record id – Contains the data for the other record.

Sample file layout structure.

888 A

000 8001 VAC 1981-09-12 1981-09-26 14 .0 P Y

888 A

000 8001 VAC 1983-03-02 1983-03-07 5 .0 P Y

888 A

000 8001 VAC 1983-08-26 1983-09-10 13 .0 P Y

888 A

000 8516 MAT 1986-06-06 1986-08-01 56 .0 P Y

- Ganesh A.M

 

0 comments: