Đ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],


'<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, 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

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


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á)

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

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

I can do this job

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

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á)

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á)

I am ready to work.

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

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á)