01-30-2008
Executing Stored Proc from unix prompt.
Hi All,
I want to run/execute a stored procedure (sybase) from unix command prompt not by login in isql utility which is provided my Sybase guys.
Is there way ..?
Thanks in advance for your help !!!
Regards,
Arvind S.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Can someone tell me how to execute an Oracle Stored Procedure from a Korn Shell Script.
Previously, I'm able to execute standard sql using the following:-
The_Output=`sqlplus................. << EOF
select count(*) from abc
/
... (3 Replies)
Discussion started by: Vinny_Mitchell
3 Replies
2. Solaris
All,
We are contemplating a port of an existing software product and would like to expend as little effort as possible. Our new database would be MS-SQL, and we would write stored procedures to perform common db operations. We'd like to call these stored procedures from C or C++ code running... (3 Replies)
Discussion started by: mparks
3 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
Want to know if is it possible to run / execute any stored procedures (sybase) from unix command prompt.?
Thanks for your help in Advance.
Regards,
Arvind S. (0 Replies)
Discussion started by: Arvind_temp
0 Replies
4. Shell Programming and Scripting
Greetings,
I need to make an open server call to a shell script from inside a Sybase Stored procedure.
Coul any one please provide a sample code?
TIA (0 Replies)
Discussion started by: rajpreetsidhu
0 Replies
5. Shell Programming and Scripting
Hi,
I am writing a script that needs to call a stored proc which would update a column in a table based on a condition.
I need to also capture the number of rows updated.
However, When I execute the script I keep getting this error:
./test_isql.sh: syntax error at line 33: `end of file'... (3 Replies)
Discussion started by: karthikk
3 Replies
6. UNIX and Linux Applications
I have a very simple set up
I am connecting to a MS SQL db using SQSH statement from a shell script
In this sqsh connection i am trying to execute a stored proc
However I want to capture the value returned by the stored proc.
I haven't really come across anything useful so far which would... (0 Replies)
Discussion started by: shishirkotkar
0 Replies
7. Shell Programming and Scripting
below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent.
sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF
set serverout on
set feed off
set head off
set pages 0
set colsep ,
set tab off
set lin 150... (3 Replies)
Discussion started by: katakamvivek
3 Replies
8. Shell Programming and Scripting
Greeting everyone. Ok, I have spent the past few days googling for this and I keep hitting a wall. Many results brought me here, but the solutions were not quite right for this.
Basically my script (ksh) is run with an arg for a csv. My script so far appears to be storing the values from my... (4 Replies)
Discussion started by: dezdiggler
4 Replies
9. Post Here to Contact Site Administrators and Moderators
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 tried to find a solution but when i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
1 Replies
10. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: Arun619
1 Replies
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)