simple unix shell script needed

IN PROGRESS
Bids
7
Avg Bid (USD)
$31
Project Budget (USD)
$30 - $35

Project Description:
i like to extract data(job information) from sybase database into single excel or csv file.
i am getting the job parameter from 2 different script(script_1,script_2) which i already ahve in 2 files(file1,file2).
now what my requirement is

1.i want to make a 3rd script(script_3) which will accept job_id as input and run a query( i will provide) and provide ouput in a file(file3).
this script will also join the output of the 3 script(file1,file2,file3) in a single csv or excel(file).
the 3 files has a common parameter as job_id.we can join the file using this job_id.

OTHER INFORMATION is attached in file.

below is sample output of 3 script and information about my system.

the information about OS:
Operating system -SunOS
Hostname - pasa21
Operating system version - 5.8
Operating update level - GEneric_117350-25
Hw System type - sun4u
Processor - sparc

the query i am running in sybase database through script:

fsql -S NYP_REP_ARCH -U reparch_support -P miT2rXp6jK >>file3<<!

use metadata;
select j.Job_ID, j.Job_Name, j.Integration_Group_ID,
jr.Report_ID, r.Report_Name,r.Subject_ID, r.isActive,
str_REPLACE((str_REPLACE(convert(varchar(120),CustomBlob),
'<OwnJobBy><UserGroup name="','')),
'" /></OwnJobBy>','') as OwnJobBy
from Job j, Job_Report jr, Report r, Job_CustomBlob jc
where r.isActive = "Y"
and j.Job_ID = jr.Job_ID
and jr.Report_ID = r.Report_ID
and j.Job_ID = jc.Job_ID
and jc.CustomBlob_Type='OwnJobBy'
and j.Job_ID='$line' # will read job_id from a input file

OTHER INFORMATION is attached in file.

Skills required:
Linux, Oracle, Shell Script, UNIX
Additional Files: job_extract.txt
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire sureshv120
$ 30
in 3 days
$ 30
in 2 days
Hire puneethmech
$ 30
in 2 days
Hire kkolukul
$ 30
in 1 days
Hire Raj30m
$ 30
in 7 days
Hire dhriti72
$ 30
in 2 days
Hire grtdeveloper
$ 35
in 1 days