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 a Sybase Stored procedure from a UNIX Script

Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
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 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. and i dont have input parameters here.

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
Calling Sybase Stored proc from UNIX Shellscript.
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 tried to find a solution but when i try to run the script i am not getting the output file with...... Post Here to Contact Site Administrators and Moderators
1
Post Here to Contact Site Administrators and Moderators
Execute stored procedure through script in sybase database and store the output in a .csv file
amit.mathur08
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...... Shell Programming and Scripting
8
Shell Programming and Scripting
Calling stored procedure from unix
gohan3376
Hi, My stored procedure returns a value. How to retrieve the value and display in unix. Stored procedure CREATE OR REPLACE PROCEDURE gohan(num INT) IS BEGIN DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num); END; Unix Scripting i used sqlplus -s...... UNIX for Dummies Questions & Answers
7
UNIX for Dummies Questions & Answers
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
Calling an Oracle Stored Procedure from Unix shell script
Leojhose
hai, can anybody say how to call or to execute an oracle stored procedure in oracle from unix... thanks in advance.... for ur reply.... by, leo... Shell Programming and Scripting
2
Shell Programming and Scripting

Featured Tech Videos