Different data layout in a single sequential file

suja.somu · Post by **suja.somu** » Wed Sep 11, 2013 3:59 pm

Is it possible to create a single fixed width sequential file from different data layouts?

the data layout are as :
Header record ( 1 record)
Detail records ( multiple records)
trailer record ( 1 record)

ray.wurlod · Post by **ray.wurlod** » Wed Sep 11, 2013 4:35 pm

suja.somu · Post by **suja.somu** » Sun Sep 15, 2013 10:43 pm

what are the ways to acheive this ? Could you please explain in detail.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 16, 2013 2:56 am

There are several paradigms.

Easiest is to write the header then append the detail and trailer.

Or you could create a dummy field with value 1 to header, 2 to detail and 3 to trailer, and use a sort/merge collector on this field to bring them together.

Just a couple of ideas.