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
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. 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
3. UNIX for Advanced & Expert Users
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
4. 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
5. Shell Programming and Scripting
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
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
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
8. 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
9. How to Post in the The UNIX and Linux Forums
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
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 PHP
sybase_connect
SYBASE_CONNECT(3) SYBASE_CONNECT(3)
sybase_connect - Opens a Sybase server connection
SYNOPSIS
resource sybase_connect ([string $servername], [string $username], [string $password], [string $charset], [string $appname], [bool
$new = false])
DESCRIPTION
sybase_connect(3) establishes a connection to a Sybase server.
In case a second call is made to sybase_connect(3) with the same arguments, no new link will be established, but instead, the link identi-
fier of the already opened link will be returned.
The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling
sybase_close(3).
PARAMETERS
o $servername
- The servername argument has to be a valid servername that is defined in the 'interfaces' file.
o $username
- Sybase user name
o $password
- Password associated with $username.
o $charset
- Specifies the charset for the connection
o $appname
- Specifies an appname for the Sybase connection. This allow you to make separate connections in the same script to the same data-
base. This may come handy when you have started a transaction in your current connection, and you need to be able to do a separate
query which cannot be performed inside this transaction.
o $new
- Whether to open a new connection or use the existing one.
RETURN VALUES
Returns a positive Sybase link identifier on success, or FALSE on failure.
CHANGELOG
+--------+------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+------------------------------------+
| 5.3.0 | |
| | |
| | The $new parameter was added. |
| | |
| 4.2.0 | |
| | |
| | The $appname parameter was added. |
| | |
| 4.0.2 | |
| | |
| | The $charset parameter was added. |
| | |
+--------+------------------------------------+
EXAMPLES
Example #1
sybase_connect(3) example
<?php
$link = sybase_connect('SYBASE', '', '')
or die("Could not connect !");
echo "Connected successfully";
sybase_close($link);
?>
SEE ALSO
sybase_pconnect(3), sybase_close(3).
PHP Documentation Group SYBASE_CONNECT(3)