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
Add header and trailer to a file
Moderators: chulett, rschirm, roy
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.
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.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
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.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson