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

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

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

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

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

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

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

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.

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.

LEARN ABOUT PHP

odbc_connect

ODBC_CONNECT(3) 							 1							   ODBC_CONNECT(3)

odbc_connect - Connect to a datasource

SYNOPSIS

       resource odbc_connect (string  $dsn, string  $user, string  $password, [int  $cursor_type])

DESCRIPTION

	The  connection id returned by this functions is needed by other ODBC functions. You can have multiple connections open at once as long as
       they either use different db or different credentials.

	With some ODBC drivers, executing a complex stored procedure may fail with an error similar to: "Cannot open a cursor on a  stored  proce-
       dure  that  has anything other than a single select statement in it". Using SQL_CUR_USE_ODBC may avoid that error. Also, some drivers don't
       support the optional row_number parameter in odbc_fetch_row(3). SQL_CUR_USE_ODBC might help in that case, too.

PARAMETERS

	      o $dsn
		- The database source name for the connection. Alternatively, a DSN-less connection string can be used.

	      o $user
		- The username.

	      o $password
		- The password.

	      o $cursor_type
		- This sets the type of cursor to be used for this connection. This parameter is not normally needed, but can be useful for  work-
		ing around problems with some ODBC drivers.  The following constants are defined for cursortype:

		     o SQL_CUR_USE_IF_NEEDED

		     o SQL_CUR_USE_ODBC

		     o SQL_CUR_USE_DRIVER

RETURN VALUES

	Returns an ODBC connection or ( FALSE) on error.

EXAMPLES

       Example #1

	      DSN-less connections

	      <?php
	      // Microsoft SQL Server using the SQL Native Client 10.0 ODBC Driver - allows connection to SQL 7, 2000, 2005 and 2008
	      $connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password);

	      // Microsoft Access
	      $connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password);

	      // Microsoft Excel
	      $excelFile = realpath('C:/ExcelData.xls');
	      $excelDir = dirname($excelFile);
	      $connection = odbc_connect("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=$excelFile;DefaultDir=$excelDir" , '', '');
	      ?>

SEE ALSO

       For persistent connections: odbc_pconnect(3).

PHP Documentation Group 													   ODBC_CONNECT(3)

UNIX and Linux Applications