Closed

simple unix shell script needed

This project received 7 bids from talented freelancers with an average bid price of $31 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
7
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 [url removed, login to view] 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, [url removed, login to view],
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 [url removed, login to view] = "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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online