Execute stored procedure through script in sybase database and store the output in a .csv file Post: 302435535

Sponsored Content

Top Forums Shell Programming and Scripting Execute stored procedure through script in sybase database and store the output in a .csv file Post 302435535 by fpmurphy on Wednesday 7th of July 2010 03:15:30 PM

07-07-2010

Registered User

Sybase does not have build-in support for outputting queries in CSV format. BCP has support for CSV but you probably do not want to down that route.

Here is one way of outputting the result of your query in CSV format. I will use the Sybase pubs2 example as the database. (the pubs2 example comes with all versions of Sybase).

Here is the contents of my shell script

Code:

isql -Uname -Ppassword -Sserver -Dpubs2 -b -h -w200  <<EOF | sed -e 's/ //g'
select '"',au_id,'","',au_fname,'","',au_lname,'","',phone,'"' from authors
go
EOF

Here is the output generated by the shell script

Code:

"172-32-1176","Johnson","White","408496-7223"
"213-46-8915","Marjorie","Green","415986-7020"
"238-95-7766","Cheryl","Carson","415548-7723"
"267-41-2394","Michael","O'Leary","408286-2428"
"274-80-9391","Dick","Straight","415834-2919"
"341-22-1782","Meander","Smith","913843-0462"
"409-56-7008","Abraham","Bennet","415658-9932"
"427-17-2319","Ann","Dull","415836-7128"
"472-27-2349","Burt","Gringlesby","707938-6445"
"486-29-1786","Chastity","Locksley","415585-4620"
"527-72-3246","Morningstar","Greene","615297-2723"
"648-92-1872","Reginald","Blotchet-Halls","503745-6402"
"672-71-3249","Akiko","Yokomoto","415935-4228"
"712-45-1867","Innes","delCastillo","615996-8275"
"722-51-5454","Michel","DeFrance","219547-9982"
"724-08-9931","Dirk","Stringer","415843-2991"
"724-80-9391","Stearns","MacFeather","415354-7128"
"756-30-7391","Livia","Karsen","415534-9219"
"807-91-6654","Sylvia","Panteley","301946-8853"
"846-92-7186","Sheryl","Hunter","415836-7128"
"893-72-1158","Heather","McBadden","707448-4982"
"899-46-2035","Anne","Ringer","801826-0752"
"998-72-3567","Albert","Ringer","801826-0752"

fpmurphy

View Public Profile for fpmurphy

Find all posts by fpmurphy

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execute an Oracle stored procedure from a shell scrip

Here is a snippet of my code: if then echo "\n Deleting all reports older than 24 hours. \n" >> $logfile ls -l $FileName >> $logfile ...

2. UNIX for Dummies Questions & Answers

execute store procedure

Hi, can someone point out the tutorial or syntax for how to execute store procedure through shell scripting . thanks.

3. Shell Programming and Scripting

How to compile a stored procedure that is there with in a script file(.sql) in unix

Hi, How can i compile the procedure code that is there in a script file (.sql) in unix.

4. Shell Programming and Scripting

how to store the return values of stored procedure in unix shell script.

hi i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh). the called stored procedure returns some values through OUT variables i want to assign the return values of stored procedure in to unix shell script variable. can you provide me the code. ...

5. Shell Programming and Scripting

Call and redirect output of Oracle stored procedure from unix script

Hi, Can you assist me in how to redirect the output of oracle stored procedure from unix script? Something similar to what i did for sybase isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %% proc_my_test 8 go %% Thanks in advance - jak

6. Shell Programming and Scripting

How to execute the stored procedure from shell script

How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file.

7. Shell Programming and Scripting

Shell Linux to connect to a database and execute store procedure

HI, i want to write a script (Linux) that: 1) connect to a database oracle 2) execute some store procedure. Can anybody help me, please? Thanks a lot Andrew

8. Shell Programming and Scripting

Unable to execute Stored Procedure from CRON

Hi, I am very new to this environment - I hope this is the right platform to discuss my issue: I created a CRON job to run a Stored Procedure from our database - Sybase. Within the Stored Procedure there is a TRUNCATE table and CREATE table function. the CRON job fails to run with...

9. Shell Programming and Scripting

ksh and Oracle stored procedure output in logfile

Friends, I pass some runtime arguments (date, number) through ksh script to Oracle procedure, use input value and pass it on to procedure. Oracle procedure gets input value, run query and logs everything in the logfile. I'm facing with couple of challenges 1. Even though I pass all...

10. How to Post in the The UNIX and Linux Forums

Calling a Sybase Stored procedure from a UNIX Script

Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File.somehow i try to find a solution but whwn i try to run the script i am not getting the output file with...

LEARN ABOUT DEBIAN

apache::session::serialize::sybase

Apache::Session::Serialize::Sybase(3pm) 		User Contributed Perl Documentation		   Apache::Session::Serialize::Sybase(3pm)

NAME

       Apache::Session::Serialize::Sybase - Use Storable to zip up persistent data and unpack/pack to put into Sybase-compatible image field

SYNOPSIS

	use Apache::Session::Serialize::Sybase;

	$zipped = Apache::Session::Serialize::Sybase::serialize($ref);
	$ref = Apache::Session::Serialize::Sybase::unserialize($zipped);

DESCRIPTION

       This module fulfills the serialization interface of Apache::Session by taking the data from Apache::Session::Serialize::Storable and
       modifying it to work with Sybase IMAGE fields. Note that you do not need to quote these values before inserting into the database, and that
       if you are using DBI::Sybase, you cannot use the data in a placeholder. If you use Apache::Session::Sybase as your session class, this will
       all get taken care of.

AUTHOR

       Apache::Session::Serialize::Storable was written by Jeffrey William Baker <jwbaker@acm.org>; the Sybase-specific data manipulation was
       written by Mark Landry <mdlandry@lincoln.midcoast.com> for use in an earlier version of Apache::Session::DBI::Sybase and placed here by
       Chris Winters <chris@cwinters.com>.

SEE ALSO

       Apache::Session::Serialize::Storable, Apache::Session::Sybase

perl v5.10.1							    2010-10-18				   Apache::Session::Serialize::Sybase(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execute an Oracle stored procedure from a shell scrip

Discussion started by: mh53j_fe

2. UNIX for Dummies Questions & Answers

execute store procedure

Discussion started by: epall

3. Shell Programming and Scripting

How to compile a stored procedure that is there with in a script file(.sql) in unix

Discussion started by: krishna_gnv

4. Shell Programming and Scripting

how to store the return values of stored procedure in unix shell script.

Discussion started by: barani75