Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

how to write into an Excell

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how to write into an Excell
# 1  
Old 07-28-2006
Error how to write into an Excell
Hello All,
I have a query inside a shell script and it will retun a 1000 rows result set. how can i take the output into an excel file from the script for better viewing the results.

Thanks,
Sateesh
# 2  
Old 07-28-2006
Tools
hi,

U can use

isql -Username -Ppassword -Ddatabse -Sserver -iinputfilename -ooutputfilename -w1200 -s,

Here input filenaem should cntin the query you want

Ex:

inputfilename

select * from Accounts
go

note go should be there


Thanks,
Arun
# 3  
Old 07-28-2006
Thanks Anil,
How about if i have a stored proc but not a sql query
# 4  
Old 07-28-2006
HI,

First i am not Anil i am arun

second

if u are running a proc u can do as


inputfilename

select * from Accounts
go


instead of

inputfile name

exec yourproc
go


Thanks,
Arun.
# 5  
Old 07-28-2006
Sorry for specifing the wrong name Arun. I will try this.
Thanks for your help.

Thanks,
Sateesh
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

Interactive Python 3.5+ sys.stdout.write() AND sys.stderr.write() bug?

(Apologies for any typos.) OSX 10.12.3 AND Windows 10. This is for the serious Python experts on at least 3.5.x and above... In script format sys.stdout.write() AND sys.stderr.write() seems to work correctly. Have I found a serious bug in the interactive sys.stdout.write() AND... (2 Replies)
Discussion started by: wisecracker
2 Replies

2. Shell Programming and Scripting

Trimmean of Excell in awk

Anyone know how we can implement excel trimmean avg in Unix. possible by AWK Sample File scr1 100 scr1 2000 scr2 320 scr1 50 scr1 10 scr2 2 scr2 220 scr1 4234 scr2 2435 scr2 2 scr3 345 scr2 356 expected Output, which was using =trimmean(scr1 values, ignore 50% of values from... (8 Replies)
Discussion started by: mychbears
8 Replies

3. Shell Programming and Scripting

Is it possible to write write multiple cronjobs in shellscript??

Hi All, I need the answer of below question? 1) How to write multiple cronjobs in shellscript? Is there any way or we cant write in shellscript... Regards, Priyanka (2 Replies)
Discussion started by: pspriyanka
2 Replies

4. Shell Programming and Scripting

PERL excell scripting

Hi, At the minute I am using a script to gather weekly SAR stats and put them into an excel scpreadsheet using perl. I then get that spreadsheet and manually add in a chart on a new worksheet, Can i add this step into the script? and if so how? here is the part of my script that creates the... (9 Replies)
Discussion started by: Bdoydie
9 Replies

5. Programming

Write-Write on a socket

Can anyone tell what happens if each end writes at the same time on the same socket ? - if one of them issues a read() after write() has completed, will it record into the buffer what the other sent ? ex. e1 writes to e2 - - - while - - - e2 writes to e1 (at the same time) e1 read () - what... (1 Reply)
Discussion started by: gendaox
1 Replies

6. IP Networking

read/write,write/write lock with smbclient fails

Hi, We have smb client running on two of the linux boxes and smb server on another linux system. During a backup operation which uses smb, read of a file was allowed while write to the same file was going on.Also simultaneous writes to the same file were allowed.Following are the settings in the... (1 Reply)
Discussion started by: swatidas11
1 Replies

7. UNIX for Dummies Questions & Answers

From Ascii files to Excell

Hi, Is there anyway to copy a certain column from the Ascii file into a column on an Excel sheet? Thanks, (4 Replies)
Discussion started by: cosmologist
4 Replies

8. Shell Programming and Scripting

Find all files with group read OR group write OR user write permission

I need to find all the files that have group Read or Write permission or files that have user write permission. This is what I have so far: find . -exec ls -l {} \; | awk '/-...rw..w./ {print $1 " " $3 " " $4 " " $9}' It shows me all files where group read = true, group write = true... (5 Replies)
Discussion started by: shunter63
5 Replies

9. Shell Programming and Scripting

how to write

hi buddies i want to write a awk script for the file like this: Aaj rootha huwa ek dost bahut yaad aaya, Achha guzra huwa kuch waqt bahut yaad aaya, Meri aankhon ke har ek ashq pe rone wala, Aaj jab aankh yeh royi to bahut yaad aaya, Jo mere dard ko seene mein chhupa leta thaa, Jo... (2 Replies)
Discussion started by: LAKSHMI NARAYAN
2 Replies
Login or Register to Ask a Question