Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


Calling Sybase Stored proc from UNIX Shellscript.


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
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 the desired records. i have created the input file "test.sql" which executes the SP and all the server details and input output file details are in ".SH file" i have the Output file also in the same location. i tried to execute the SP in rapid sql and found that the SP works well.

Please correct me if i am wrong anywhere. and this is an Urgent requirement.

.SH FILE :
#!/bin/ksh -x

isql -S${Servername} -D${Database name } -I$ test.Sql -O$ Outfile.OUT -U${username} -P${password}

INPUT FILE: test.sql

use BenefitDB
go

exec Sample_SP
go
# 2  
Moderator's Comments:
Mod Comment This thread is file in an inappropriate forum and duplicates the thread Sybase Stored Proc call from UNIX script.

Continue any discussion on this topic there.

This thread is closed.
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Sybase Stored Proc call from UNIX script.
Arun619
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...... Shell Programming and Scripting
1
Shell Programming and Scripting
Calling a Sybase Stored procedure from a UNIX Script
Arun619
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...... How to Post in the The UNIX and Linux Forums
1
How to Post in the The UNIX and Linux Forums
Error when calling sybase stored proc from shell script
karthikk
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'...... Shell Programming and Scripting
3
Shell Programming and Scripting
Executing Shell Script from Within a Sybase Stored Proc
rajpreetsidhu
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... Shell Programming and Scripting
0
Shell Programming and Scripting
Executing Stored Proc from unix prompt.
arvindcgi
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.... UNIX for Advanced & Expert Users
0
UNIX for Advanced & Expert Users

Featured Tech Videos