generate report while through datastage JOB

[arasan]

Can any one help me out on how to genarate a report during the job run.

for example

source >>>>trasformer>>>>>sequential file

source: emp table

target: sequential file

emp_id,name,sal
101,p,200
102,c,300

while running the job it should generate a report in such a way

header employee details

emp_id,name,sal
101,p,200
102,c,300

footer current date

whether datastage can handle the report generation of the format we require?If so pls explain....

[ray.wurlod]

In before-job subroutine choose ExecSH and execute an echo command to write the header line.
echo Employee Details > #filename#

In the sequential stage name #filename#, but choose Append To File

In after-job subroutine choose Exec SH and execute an echo command to append the current date as the trailer line.
echo `date` >> #filename#