Đang Thực Hiện

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.

Kỹ năng: Linux, Oracle, Shell Script, UNIX

Xem thêm: 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

Về Bên Thuê:
( 0 nhận xét ) Pune, India

Mã Dự Án: #1637687

7 freelancer đang chào giá trung bình $31 cho công việc này

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 trong 3 ngày
(6 Đánh Giá)
3.0
lokeshk9936

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

$30 USD trong 2 ngày
(3 Đánh Giá)
3.0
puneethmech

I can do this job

$30 USD trong 2 ngày
(1 Đánh Giá)
2.7
kkolukul

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

$30 USD trong 1 ngày
(2 Đánh Giá)
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 Thêm

$30 USD trong 2 ngày
(0 Đánh Giá)
0.0
Raj30m

I am ready to work.

$30 USD trong 7 ngày
(0 Đánh Giá)
0.0
grtdeveloper

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

$35 USD trong 1 ngày
(1 Đánh Giá)
0.0