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, linux processor type, file processor, database processor, common query, simple unix shell script, file2, 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, join shell script, unix join, simple script excel, update data excel script

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