Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

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

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications How to capture the value returned by a stored proc while executing it from SQSH connection
# 1  
Old 01-11-2012
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 help me solve the problem.

Code snippet is something like below
HTML Code:
sqsh -Uuser -Ppasswd -Sserver <<EOF
use Database
go
exec stored_prod
go
EOF
Login or Register to Ask a Question

Previous Thread | Next Thread

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. 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

3. 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

4. Shell Programming and Scripting

Capture query returned values in file.

Hi All, I am connecting to Oracle DB from UNIX script. Want to capture all dates between start date and end date and store them in file. Once this is done, want to read dates one by one. How to achive this in UNIX and Oracle? Please let me know if you have any idea on the same. Thanks and... (4 Replies)
Discussion started by: Nagaraja Akkiva
4 Replies

5. 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

6. Shell Programming and Scripting

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

7. UNIX for Advanced & Expert Users

capture sqsh segmentation fault error

hi all is there any way to capture the segmentation fault error when i run sqsh on a unix shell script. Ex: #!/bin/ksh sqsh -S "server" -U "user" -P "pwd" << EOF use mydb go exec proc1 go exit EOF retval=$? echo "sqsh return value $retval" if then exit (1 Reply)
Discussion started by: sudheer1984
1 Replies

8. Shell Programming and Scripting

script or piece of code where the data returned by a stored procedure you are writing

hi fndz. Can you please help me with the code if I call a stored procedure from my shell script and stored procedure returns a cursor, cursor output should be saved to a file (3 Replies)
Discussion started by: enigma_83
3 Replies

9. 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

10. 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
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

evtest-capture

EVTEST-CAPTURE(1)														 EVTEST-CAPTURE(1)

NAME

       evtest-capture - Input device event capture program

SYNOPSIS

       evtest-capture "/dev/input/eventX" [evtest-capture.xml]

DESCRIPTION

       evtest-capture captures the information and events from the input device specified on the command line and writes it to the xml file given.
       If no filename is given for the output file, evtest-capture.xml is chosen as default.

       evtest-capture needs to be able to read from the device; in most cases this means it must be run as root.

       Together with with evtest-create-device.xsl, a simple uinput-based software input device can be created that replays the events as if the
       same input was performed on the physical device. This can be useful to replicate bugs with input devices in upper layers of the stack.

       To convert evtest-capture.xml into such a uinput device, run:

	   xsltproc evtest-create-device.xls evtest-capture.xml > mydevice.c
	   gcc -o mydevice mydevice.c
	   ./mydevice

DIAGNOSTICS

       If evtest-capture does not see any events even though the device is being used, the device may be grabbed by a process (EVIOCGRAB). This is
       usually the case when debugging a synaptics device from within X. VT switching to a TTY or shutting down the X server terminates this grab
       and synaptics devices can be debugged.

SEE ALSO

       evtest(1)

AUTHOR

       evtest-capture was written by Peter Hutterer <peter.hutterer@redhat.com[1]>.

NOTES

	1. peter.hutterer@redhat.com
	   mailto:peter.hutterer@redhat.com

								    05/21/2012							 EVTEST-CAPTURE(1)