Executing Stored Proc from unic prompt.

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

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

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. Shell Programming and Scripting

Stored Procedure not executing

below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent. sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF set serverout on set feed off set head off set pages 0 set colsep , set tab off set lin 150...

5. UNIX and Linux Applications

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

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

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

9. Solaris

Executing MS-SQL stored procedures from Unix/C Program?

All, We are contemplating a port of an existing software product and would like to expend as little effort as possible. Our new database would be MS-SQL, and we would write stored procedures to perform common db operations. We'd like to call these stored procedures from C or C++ code running...

10. UNIX for Dummies Questions & Answers

Executing Oracle Stored Procs from Korn Shell

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

LEARN ABOUT HPUX

xhpacknowledge

XHPAcknowledge(3X)														XHPAcknowledge(3X)

NAME

       XHPAcknowledge - Send an Acknowledge to an extended input device.

SYNOPSIS

       #include <X11/XHPlib.h>

       int XHPAcknowledge (display, deviceid, acknowledge)
	    Display	   *display;
	    XID       deviceid;
	    int       acknowledge;

ARGUMENTS

       display	   Specifies the connection to the X server.

       deviceid    Specifies the ID of the desired device.

       acknowledge Specifies the acknowledge to be sent.  Valid values are: GENERAL_ACKNOWLEDGE, ACKNOWLEDGE_1, ACKNOWLEDGE_2, ACKNOWLEDGE_3,
		   ACKNOWLEDGE_4, ACKNOWLEDGE_5, ACKNOWLEDGE_6, ACKNOWLEDGE_7.

DESCRIPTION

       This request is part of an HP-proprietary extension to X.  Its functionality has been superseded by the standard XChangeFeedbackControl
       request.  You should use XChangeFeedbackControl instead of XHPAcknowledge if possible.

       This request sends an acknowledge to an input device.  This allows a previously received prompt to be turned off.

       A prompt is an audio or visual indication that the program controlling the input device is ready for input.  The LED on an HP46086A
       buttonbox is an example of a prompt.  A program may indicate its status by turning on a prompt on the appropriate input device.

       Not all input devices support prompts and acknowledges.	Any device that does support a particular prompt will also support the
       corresponding acknowledge.

       To determine whether an input device supports a particular prompt and acknowledge, the io_byte field of the XHPDeviceList structure should
       be examined.  The format of this structure is described in the documentation for the XHPListInputDevices request.

RETURN VALUE

       none

DIAGNOSTICS

       BadDevice   An invalid device ID was specified.

       BadValue    An invalid acknowledge was specified.

FILES

       /usr/include/X11/XHPlib.h

ORIGIN

       Hewlett-Packard Company

SEE ALSO

       XHPListInputDevices(3x)
       XHPPrompt(3x)

X Version 11							     Release 5							XHPAcknowledge(3X)

UNIX for Dummies Questions & Answers