Calling Sybase Stored proc from UNIX Shellscript. Post: 302990240

10 More Discussions You Might Find Interesting

1. Solaris

Calling Oracle Stored Procedures in UNIx(sun solaris)

I have created 3 Procedures all similar to this one: I then created 3 shell sripts which will call the sql? finally created a calling script to call the procedure. I am a bit unsure how to this all works, can someone check my code and I am doing this right? Also could I add my procedure (first...

2. Shell Programming and Scripting

Calling an Oracle Stored Procedure from Unix shell script

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

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

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

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

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

7. UNIX for Dummies Questions & Answers

Calling stored procedure from unix

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

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

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

10. Shell Programming and Scripting

Sybase Stored Proc call from UNIX script.

LEARN ABOUT LINUX

tkill

TKILL(2)						     Linux Programmer's Manual							  TKILL(2)

NAME

       tkill, tgkill - send a signal to a thread

SYNOPSIS

       int tkill(int tid, int sig);

       int tgkill(int tgid, int tid, int sig);

DESCRIPTION

       tgkill()  sends	the  signal  sig to the thread with the thread ID tid in the thread group tgid.  (By contrast, kill(2) can only be used to
       send a signal to a process (i.e., thread group) as a whole, and the signal will be delivered to an arbitrary thread within that process.)

       tkill() is an obsolete predecessor to tgkill().	It only allows the target thread ID to be specified, which may result in the wrong  thread
       being signaled if a thread terminates and its thread ID is recycled.  Avoid using this system call.

       If tgid is specified as -1, tgkill() is equivalent to tkill().

       These are the raw system call interfaces, meant for internal thread library use.

RETURN VALUE

       On success, zero is returned.  On error, -1 is returned, and errno is set appropriately.

ERRORS

       EINVAL An invalid thread ID, thread group ID, or signal was specified.

       EPERM  Permission denied.  For the required permissions, see kill(2).

       ESRCH  No process with the specified thread ID (and thread group ID) exists.

VERSIONS

       tkill() is supported since Linux 2.4.19 / 2.5.4.  tgkill() was added in Linux 2.5.75.

CONFORMING TO

       tkill() and tgkill() are Linux-specific and should not be used in programs that are intended to be portable.

NOTES

       See the description of CLONE_THREAD in clone(2) for an explanation of thread groups.

       Glibc does not provide wrappers for these system calls; call them using syscall(2).

SEE ALSO

       clone(2), gettid(2), kill(2)

COLOPHON

       This  page is part of release 3.27 of the Linux man-pages project.  A description of the project, and information about reporting bugs, can
       be found at http://www.kernel.org/doc/man-pages/.

Linux								    2008-10-01								  TKILL(2)