En cours

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.

Compétences : Linux, Oracle, Script Shell, UNIX

Voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Pune, India

N° du projet : #1637687

7 freelance ont fait une offre moyenne de 31 $ pour ce travail

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 en 3 jours
(6 Commentaires)
3.0
lokeshk9936

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

30 $ USD en 2 jours
(3 Commentaires)
3.0
puneethmech

I can do this job

30 $ USD en 2 jours
(1 Commentaire)
2.7
kkolukul

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

30 $ USD en 1 jour
(2 Commentaires)
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 Plus

30 $ USD en 2 jours
(0 Commentaires)
0.0
Raj30m

I am ready to work.

30 $ USD en 7 jours
(0 Commentaires)
0.0
grtdeveloper

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

35 $ USD en 1 jour
(1 Commentaire)
0.0