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
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.

Skills Required

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