DSXchange

Hi,

How do I add header and trailer record to a file. My header record is run date and the trailer record is number of records.

I searched in the forum and found a method to create 3 files and then cat all the files.Is there any other option in version 8 or can it be done in datastage?

Thanks

Couple of ways:

1. Create your header as part of before job subroutine, append the data to the flat file in your job and create the trailer in the after job subroutine.

2. Have a Transformer with three output links going into a Funnel Stage. Select sequential operation within your funnel stage. Create your header and trailer records in two links and output the data through the other link. Write the output of the funnel to a flat file.

Thanks for your suggestion.

On your first method, when you say before and after, should I actually execute unix command to create a header file.

Thanks

Yes. you need to use UNIX commands. But you don't have to create a header file separately. You can create the header and write it to the output file. In the parallel job, set your Update to Append rather overwrite within the sequential file and in the after job, create your trailer record and append it to the sequential file again.