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

db2_prepare

DB2_PREPARE(3)								 1							    DB2_PREPARE(3)

db2_prepare - Prepares an SQL statement to be executed

SYNOPSIS

       resource db2_prepare (resource  $connection, string  $statement, [array	$options])

DESCRIPTION

       db2_prepare(3)  creates	a prepared SQL statement which can include 0 or more parameter markers ( ? characters) representing parameters for
       input, output, or input/output. You can pass parameters to the prepared statement using db2_bind_param(3), or for input values only, as	an
       array passed to db2_execute(3).

	There are three main advantages to using prepared statements in your application:

	      o Performance:  when  you  prepare  a  statement, the database server creates an optimized access plan for retrieving data with that
		statement. Subsequently issuing the prepared statement with db2_execute(3) enables the statements to reuse that  access  plan  and
		avoids the overhead of dynamically creating a new access plan for every statement you issue.

	      o Security:  when you prepare a statement, you can include parameter markers for input values. When you execute a prepared statement
		with input values for placeholders, the database server checks each input value to ensure that the type matches the column defini-
		tion or parameter definition.

	      o Advanced  functionality:  Parameter  markers not only enable you to pass input values to prepared SQL statements, they also enable
		you to retrieve OUT and INOUT parameters from stored procedures using db2_bind_param(3).

PARAMETERS

	      o $connection
		- A valid database connection resource variable as returned from db2_connect(3) or db2_pconnect(3).

	      o $statement
		- An SQL statement, optionally containing one or more parameter markers..

	      o $options
		- An associative array containing statement options. You can use this parameter to request a scrollable cursor on database servers
		that support this functionality.  For a description of valid statement options, see db2_set_option(3).

RETURN VALUES

	Returns  a statement resource if the SQL statement was successfully parsed and prepared by the database server. Returns FALSE if the data-
       base server returned an error. You can determine which error was returned by calling db2_stmt_error(3) or db2_stmt_errormsg(3).

EXAMPLES

       Example #1

	      Preparing and executing an SQL statement with parameter markers

	       The following example prepares an INSERT statement that accepts four parameter markers, then iterates over an array of arrays  con-
	      taining the input values to be passed to db2_execute(3).

	      <?php
	      $animals = array(
		  array(0, 'cat', 'Pook', 3.2),
		  array(1, 'dog', 'Peaches', 12.3),
		  array(2, 'horse', 'Smarty', 350.0),
	      );

	      $insert = 'INSERT INTO animals (id, breed, name, weight)
		  VALUES (?, ?, ?, ?)';
	      $stmt = db2_prepare($conn, $insert);
	      if ($stmt) {
		  foreach ($animals as $animal) {
		      $result = db2_execute($stmt, $animal);
		  }
	      }
	      ?>

SEE ALSO

       db2_bind_param(3), db2_execute(3), db2_stmt_error(3), db2_stmt_errormsg(3).

PHP Documentation Group 													    DB2_PREPARE(3)

UNIX and Linux Applications