Visit Our UNIX and Linux User Community


Executing Shell Script from Within a Sybase Stored Proc


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Executing Shell Script from Within a Sybase Stored Proc
# 1  
Old 08-20-2009
Executing Shell Script from Within a Sybase Stored Proc

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

Previous Thread | Next Thread
Test Your Knowledge in Computers #441
Difficulty: Easy
"Hotel California" by the Eagles is a song about a super A.I. who goes rouge and parties all day and night.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sybase Stored Proc call from 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... (1 Reply)
Discussion started by: Arun619
1 Replies

2. 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... (1 Reply)
Discussion started by: Arun619
1 Replies

3. Post Here to Contact Site Administrators and Moderators

Calling Sybase Stored proc from UNIX Shellscript.

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

4. Shell Programming and Scripting

PL/SQL stored proc from ksh just inserts thumb and does nothing

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

5. UNIX and Linux Applications

How to capture the value returned by a stored proc while executing it from SQSH connection

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

6. Shell Programming and Scripting

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

Hi, I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output. I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Discussion started by: amit.mathur08
8 Replies

7. Shell Programming and Scripting

Error when calling sybase stored proc from shell script

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

8. UNIX for Advanced & Expert Users

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. (0 Replies)
Discussion started by: arvindcgi
0 Replies

9. UNIX for Dummies Questions & Answers

Executing Stored Proc from unic prompt.

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

10. UNIX for Dummies Questions & Answers

Executing Oracle Stored Procs from Korn Shell

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
Apache::Session::Store::Sybase(3pm)			User Contributed Perl Documentation		       Apache::Session::Store::Sybase(3pm)

NAME
Apache::Session::Store::Sybase - Store persistent data in a Sybase database SYNOPSIS
use Apache::Session::Store::Sybase; my $store = new Apache::Session::Store::MySQL; $store->insert( $ref ); $store->update( $ref ); $store->materialize( $ref ); $store->remove( $ref ); DESCRIPTION
Apache::Session::Store::Sybase fulfills the storage interface of Apache::Session. Session data is stored in a Sybase database. SCHEMA
To use this module, you will need at least these columns in a table called 'sessions': id CHAR(32) # or however long your session IDs are. a_session IMAGE To create this schema, you can execute this command using the isql or sqsh programs: CREATE TABLE sessions ( id CHAR(32) not null primary key, a_session TEXT ) go If you use some other command, ensure that there is a unique index on the id column of the table CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the options hash (see Apache::Session documentation). The options are: DataSource UserName Password Example: tie %hash, 'Apache::Session::Sybase', $id, { DataSource => 'dbi:Sybase:database=db;server=server', UserName => 'database_user', Password => 'K00l', Commit => 1, }; Instead, you may pass in an already-opened DBI handle to your database. tie %hash, 'Apache::Session::Sybase', $id, { Handle => $dbh }; Additional arguments you can pass to the backing store are: Commit - whether we should commit any changes; if you pass in an already-open database handle that has AutoCommit set to a true value, you do not need to set this. If you let Apache::Session::Store::Sybase create your database, handle, you must set this to a true value, otherwise, your changes will not be saved textsize - the value we should pass to the 'set textsize ' command that sets the max size of the IMAGE field. Default is 32K (at least in Sybase ASE 11.9.2). AUTHOR
This module was based on Apache::Session::Store::Oracle which was written by Jeffrey William Baker <jwbaker@acm.org>; it was modified by Chris Winters <chris@cwinters.com> to work with Apache::Session 1.5+ with changes from earlier version of Apache::Session::DBI::Sybase from Mark Landry <mdlandry@lincoln.midcoast.com>. SEE ALSO
Apache::Session perl v5.10.1 2010-10-18 Apache::Session::Store::Sybase(3pm)

Featured Tech Videos