Generate a Sequential file with a header and footer??

[DeepakCorning]

We have a requirement to write to a sequential file from a table. its not complex and is one to one mapping. But the thing is that we want to include a header and a footer to the file. Is it possible to do it in Datasatge??

I was wondering a work out such as union with a dummy table to generate this header row, but will like to know if there is a direct function present in datasatge or not?

[chulett]

Typically, you'll want to generate the three files separately - header, detail, footer - and then cat them together in the proper order after job.

[Shree0410]

3 jobs, the one that creats header, should be a 'overwrite' of the file, means new and the one that extracts data from table will be second in the sequence which appends and then the third one that writes the trailer will be the last in the sequence that should also append

[chulett]

I stick with one job to create all three files, then cat.

[DSguru2B]

Jules agrees with Craig.

[parag.s.27]

Yes you can do it in a single job......
just create 3 files with header, details and footer....

and then use Link collector having proper link execution order...

[DSguru2B]

Yes you can do it in a single job......
just create 3 files with header, details and footer....

and then use Link collector having proper link execution order...

I dont think that would work, unless the "details" has a single record.

[kumar_s]

Or before job subroutine to create a file with header. And append the file in the job with detail. And later cat with the trailer in after job subroutine.

[parag.s.27]

no it will coz i did that just include 2 stage variables stgcnt1 and stgcnt2

then increment as stgcnt1+1 for stgcnt1
and
stgcnt2+1 for stgcnt2

and apply constraint..
for header- if stgcnt1=1 then.......
then simply details
and then footer as
if stgcnt2=1....

coz this will be satisfied only once

[parag.s.27]

to be more precise

Code: Select all

    Header Data sequential file
               |if Stgcnt1=1 then (write the header data)1\
               |                                                              
------>transformer--------->details2----------------2---Link collector
               |                                                         
               |if Stgcnt2=1 then (write footer data)3--/
    footer Data sequential file

[DSguru2B]

Thats fine. But the link collector will go for roundrobin processing. It will take the first record from 1, first record from 2 and then first record from 3, then come back to 2 and continue.
SO your output file will look like
header
detail
trailer
detail
detail
.......
.......
.......
.......
Thats what i mean. Its not the logic inside the transformer, its the way link collector will work.

[parag.s.27]

My mistake as usual...

hope this will help : -

first create file with header and detail data....and then use another link collector to include trailer to that newly created file.....

yup its complex....

so
Header + Detail = 1st link collector..
then
Header + Detail + Footer = 2nd link collector

[ray.wurlod]

You could also use ExecSH (or your own routine) as a before-job subroutine to echo the header into the file, append detail records in the job and use ExecSH (or your own routine) as an after-job subroutine to append the trailer using echo and the >> redirection operator.

[DeepakCorning]

Thanks guys for replying back for this doubt. And after going through all these rplies it seems its not that easy task which i was thinkng of. Well I will try any of the solutionf and see which one works.

[chulett]

Actually, I think it's a very easy task to accomplish. You can complicate it if you like, but it really can be distilled down to one job that creates three separate files and concatendates them together when it is done. Easy Peasy.