Add Header information and add page breaks into the sequenti

[Sainath.Srinivasan]

Use a reporting tool

[chulett]

Let's get the first comment that you were going to get from someone out of the way - DataStage is an ETL tool, not a BI tool and what you have is not an ETL task. Does your company not have access to a BI tool, some kind of 'report writer' that would do a proper job of this?

Otherwise what you have is a sorting issue. Add fields to the flow that hold the page and line numbers which will allow you to generate the data in any convenient order. Then a sort stage can put them in the proper output order and you can drop those fields before the final write.

[creatingfusion]

create the header file in one sequential file seperately. then get the detail files as per yours requirement.
Then use shell script as after job subroutine to append the detail files to the header file.
I hope this would work fine as per yours requirement.
To append the header and detail files you may use the following unix command in yours shell script.

cat header_file_name detail_file_name > output_file

Let me know if this serves yours requirement.

Abhijit

[arunkumarmm]

I believe he wants to write the header in all of his pages [??].

Cant you include the header detail to your Pages 2 & 3 as you do it for your page 1??

If this is not what you are looking for, please post more details.

[Sainath.Srinivasan]

If you really want to go down this route, extend the (psuedo) code below

Code: Select all

awk '{ if ((NR%49) == 1) printf("%s\n",yourHeader)} {printf("%s\n",$0) } ' yourFileName

[arunpramanik]

What about the page break?

[Sainath.Srinivasan]

What about the page break?

What about it ?