Can SQL Server call be made from unix sh

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i...

2. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

3. UNIX for Advanced & Expert Users

Using PHP , call a sql inside a unix script

I am running the xampp on WINDOWS, and my php script is connecting to a unix script on a different server (ssh2_connect("11.31.138.56", 22). I am running the unix script and inside this script I am calling the .sql file . The SQL is connecting to oracle db on the unix server. But the sqlplus...

4. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing...

5. Shell Programming and Scripting

Call a pl sql function from unix

hi, I want to know how to call a pl sql function testfunction(param1,..) that returns a value and grab that value in a shell variable. Thnx in advance ---------- Post updated 03-30-10 at 11:58 AM ---------- Previous update was 03-29-10 at 03:49 PM ---------- thnx a lot jim

6. Shell Programming and Scripting

Unix call to Oracle PL/SQL pkg/store.proc

HI, I'm trying to get this right, please can you help. In my unix korn shell script, I call an oracle stored proc within a package and I specify 3 parameters, 2 of which are IN OUT parameters (i.e. I expect the stored proc to change them and return them back to me). Does the unix code...

7. UNIX for Advanced & Expert Users

How to call SQL procedure from UNIX Shellscript ?

Hi All I would be thankful to you all if you will guide me the steps to call a stored proc. from unix shell script. that stored proc. could be parameterised or parameterless developed in SQL. Any info. in this topic would help me..... Thanks in advance....

8. UNIX for Dummies Questions & Answers

MS SQL Server on UNIX

Hi GURUs, I have following queries: 1) If its possible to configure Microsoft SQL Server database on a UNIX machine, if yes, can any body pls point me to the guide to acheive the same. 2) I know Oracle runs perfectly on UNIX based machines, can any body point me to the guide to achieve the...

9. Shell Programming and Scripting

how can I call a pl/sql funciton in unix script

who can show me how to call pl/sql function or precudure in unix script.. cheers,

10. Shell Programming and Scripting

How to call pl/sql in unix script

sample code as following: test_sql(){ #test#echo test_sql str=`$ORACLE_BIN/sqlplus -s $user/$passwd <<EOM set verify off set heading off set feedback off #--------start pl/sql { DECLARE CURSOR pah_cs IS select id from table where letter = 'abcd';...

LEARN ABOUT PHP

sqlsrv_errors

SQLSRV_ERRORS(3)														  SQLSRV_ERRORS(3)

sqlsrv_errors - Returns error and warning information about the last SQLSRV operation performed

SYNOPSIS

       mixed sqlsrv_errors ([int  $errorsOrWarnings])

DESCRIPTION

	Returns error and warning information about the last SQLSRV operation performed.

PARAMETERS

	      o $errorsOrWarnings
		-  Determines  whether error information, warning information, or both are returned. If this parameter is not supplied, both error
		information and warning information are returned. The following are the supported values for this parameter: SQLSRV_ERR_ALL,  SQL-
		SRV_ERR_ERRORS, SQLSRV_ERR_WARNINGS.

RETURN VALUES

	If errors and/or warnings occurred on the last sqlsrv operation, an array of arrays containing error information is returned. If no errors
       and/or warnings occurred on the last sqlsrv operation, NULL is returned. The following  table  describes  the  structure  of  the  returned
       arrays:

       Array returned by sqlsrv_errors

       +---------+---------------------------------------------------+
       |  Key	 |						     |
       |	 |						     |
       |	 |		      Description		     |
       |	 |						     |
       +---------+---------------------------------------------------+
       |SQLSTATE |						     |
       |	 |						     |
       |	 | For	errors	that originate from the ODBC driver, |
       |	 | the SQLSTATE returned by ODBC.  For	errors	that |
       |	 | originate  from the Microsoft Drivers for PHP for |
       |	 | SQL Server, a SQLSTATE  of  IMSSP.  For  warnings |
       |	 | that originate from the Microsoft Drivers for PHP |
       |	 | for SQL Server, a SQLSTATE of 01SSP. 	     |
       |	 |						     |
       |  code	 |						     |
       |	 |						     |
       |	 | For errors that originate from  SQL	Server,  the |
       |	 | native  SQL	Server	error  code. For errors that |
       |	 | originate from the ODBC driver,  the  error	code |
       |	 | returned  by ODBC. For errors that originate from |
       |	 | the Microsoft Drivers for PHP for SQL Server, the |
       |	 | Microsoft  Drivers  for  PHP for SQL Server error |
       |	 | code.					     |
       |	 |						     |
       |message  |						     |
       |	 |						     |
       |	 |	      A description of the error.	     |
       |	 |						     |
       +---------+---------------------------------------------------+
EXAMPLES

       Example #1

	      functionname(3) example

	      <?php
	      $serverName = "serverName/sqlexpress";
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);
	      if( $conn === false ) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      /* Set up a query to select an invalid column name. */
	      $sql = "SELECT BadColumnName FROM Table_1";

	      /* Execution of the query will fail because of the bad column name. */
	      $stmt = sqlsrv_query( $conn, $sql );
	      if( $stmt === false ) {
		  if( ($errors = sqlsrv_errors() ) != null) {
		      foreach( $errors as $error ) {
			  echo "SQLSTATE: ".$error[ 'SQLSTATE']."<br />";
			  echo "code: ".$error[ 'code']."<br />";
			  echo "message: ".$error[ 'message']."<br />";
		      }
		  }
	      }
	      ?>

NOTES

	By default, warnings generated on a call to any SQLSRV function are treated as errors. This means that if a warning occurs on a call to  a
       SQLSRV  function, the function returns FALSE. However, warnings that correspond to SQLSTATE values 01000, 01001, 01003, and 01S02 are never
       treated as errors. For information about changing this behavior, see sqlsrv_configure(3) and the WarningsReturnAsErrors setting.

SEE ALSO

       sqlsrv_configure(3).

PHP Documentation Group 													  SQLSRV_ERRORS(3)

Shell Programming and Scripting