In Progress

simple unix shell script needed

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: Linux, Oracle, Shell Script, UNIX

See more: simple unix shell, shell script read excel file unix, linux processor type, file processor, database processor, common query, simple unix shell script, what is unix shell, in linux shell script, file2, shell script or, sybase, simple query, simple csv, shell script, r j, oracle job, jr, j query, hw, shell unix, output script, shell script csv, extract excel files, run script linux

About the Employer:
( 0 reviews ) Pune, India

Project ID: #1637687

7 freelancers are bidding on average $31 for this job

sureshv120

I have completed a total of 12 projects with a 100% completion rate and my avg rating is 5 out of 5. This means I believe in high quality and on time delivery. Please check PMB.

$30 USD in 3 days
(6 Reviews)
3.0
lokeshk9936

Hi, As discussed I can do this. Fairly simple.

$30 USD in 2 days
(3 Reviews)
3.0
puneethmech

I can do this job

$30 USD in 2 days
(1 Review)
2.7
kkolukul

Having 6+ yrs of experience in scripting and sql. Very much interested in working on your project.

$30 USD in 1 day
(2 Reviews)
2.7
dhriti72

Hi, I have over 12 years of System Admin and 5 years of Database Experience. I would be able to help you in creating this script and work with you till you are satisfied with the outcome. Looking forward to heari More

$30 USD in 2 days
(0 Reviews)
0.0
Raj30m

I am ready to work.

$30 USD in 7 days
(0 Reviews)
0.0
grtdeveloper

Hi, I am expert in shell scripting. I can do this work and is ready to start asap. Thanks

$35 USD in 1 day
(1 Review)
0.0