Supress ' quotes in a select statement inside Shell Script

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Supress java error output to shell

Hello, I know this isn't exactly a shell script question but I'm not sure where else to post it. I am running a java program out of a shell script. There are times when I get an error like, "java.lang.ArrayIndexOutOfBoundsException: 22 at blah, blah at blah, blah ...

2. Shell Programming and Scripting

How to ignore delimiters inside the quotes?

Hi Experts, How to ignore any delimiters which is inside the quotes. in awk script. I am having script which counts number of delimiters from the line now i need count delimiters only separators . `grep "14" | cut -d"=" -f2` -F'~'if (NF-1 != v1) ' this command counts number of Tilde...

3. Shell Programming and Scripting

How to call an sql script inside a while statement in KSH

Hi all, I'm trying to run an sql inside a loop which looks like this #!bin/ksh while IFS=, read var1 var2 do sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} << EOF insert into ${TABLE} ( appt_date ) values ( '${var1 }' ); ...

4. Shell Programming and Scripting

Automatically select records from several files and then run a C executable file inside the script

Dear list its my first post and i would like to greet everyone What i would like to do is select records 7 and 11 from each files in a folder then run an executable inside the script for the selected parameters. The file format is something like this 7 100 200 7 100 250 7 100 300 ...

5. Shell Programming and Scripting

using SELECT sql statement in shell script

Hi there I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this SN=123456 n=server1 m=x4140 sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';" echo $sql |/usr/sfw/bin/mysql -h...

6. Shell Programming and Scripting

How can i use single quotes for SQL command in shell script

Hi. please help me to write the following query in a shell script. the Query is :select no,salary from emp_info where name='$var_name' the following is my code. #! /bin/sh var_name=$1 sqlplus -s user/pwd@DB << EOF select no,salary from emp_info where name="'$var_name'";...

7. Shell Programming and Scripting

single quotes in awk statement

Hi, I have written a code to modify a string say, StringA=abc,def,ghi I need to change it to something like: StringB=This means abc='ABC', This mean def='DEF', This means ghi= 'GHI' StringB=$(echo $StringA | awk -F',' 'BEGIN { OFS="," } { for (i=1; i<=NF;i++) $i="This means...

8. Shell Programming and Scripting

escaping double-quotes inside the script?

I'm having a strange problem with escaping double-quotes. I have a script that looks like this: #!/bin/bash for HOST in `cat $INFILE | grep -v ^#` do for VFILER in `some_command` do echo " " echo -e '\E The problem with ssh command...

9. Windows & DOS: Issues & Discussions

Want to use the output of Select statement in Unix script

Hi, I have a UNIX script which calls SQL Select statement: Now i want to use the output of that select statement within my UNIX script so as to call different shell script depending upon the output of the select statement. Can anyone help me in this regard. TIA Akhil Goel

10. UNIX for Dummies Questions & Answers

Pipe SQL select statement results to script

Hello I would like to perform a select from a oracle table and return those values to my shell script For example: site=head -1 $infile | cut -c1-15 | awk '{printf "s%", $0} sqlplus -s /nolog |& #Open pipe to sql select col1, col2, col3, col4 from oracle_table where col5 =...

LEARN ABOUT PHP

ingres_unbuffered_query

INGRES_UNBUFFERED_QUERY(3)						 1						INGRES_UNBUFFERED_QUERY(3)

ingres_unbuffered_query - Send an unbuffered SQL query to Ingres

SYNOPSIS

       mixed ingres_unbuffered_query (resource	$link, string  $query, [array  $params], [string  $types])

DESCRIPTION

       ingres_unbuffered_query(3) sends the given $query to the Ingres server.

	The query becomes part of the currently open transaction. If there is no open transaction, ingres_unbuffered_query(3) opens a new transac-
       tion. To close the transaction, you can call either ingres_commit(3) to commit the changes made to the database	or  ingres_rollback(3)	to
       cancel  these  changes.	When  the  script  ends,  any  open  transaction  is rolled back (by calling ingres_rollback(3)). You can also use
       ingres_autocommit(3) before opening a new transaction to have every SQL query immediately committed. Ingres allows only a single unbuffered
       statement to be active at any one time. The extension will close any active unbuffered statements before executing any SQL. In addition you
       cannot use ingres_result_seek(3) to position the row before fetching.

       Note

	      Related Configurations

	       See also the ingres.describe and ingres.utf8 directives in Runtime Configuration.

PARAMETERS

	      o $link
		- The connection link identifier

	      o $query
		- A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter  in  ingres_query(3)
		for  a	list  of  SQL statements that cannot be executed via ingres_unbuffered_query(3).  Data inside the query should be properly
		escaped.

	      o $params
		- An array of parameter values to be used with the query

	      o $types
		- A string containing a sequence of types for the parameter values passed. See the types parameter in ingres_query(3) for the list
		of type codes.

RETURN VALUES

       ingres_unbuffered_query(3) returns a query result identifier when there are rows to fetch; else it returns FALSE when there are no rows, as
       is the case of an INSERT, UPDATE, or DELETE statement. To see if an error occurred, use ingres_errno(3), ingres_error(3), or ingres_errsql-
       state(3).

EXAMPLES

       Example #1

	      Issue a simple un-buffered select

	      <?php
	      $link = ingres_connect("demodb");

	      $result = ingres_unbuffered_query($link, "select * from user_profile");
	      while ($row = ingres_fetch_row($result)) {
		  echo $row[1];
		  echo $row[2];
	      }
	      ?>

       Example #2

	      Passing query parameters to ingres_unbuffered_query(3)

	      <?php
	      $link = ingres_connect("demodb");

	      $params[] = "Emma";
	      $query = "select * from user_profile where up_first = ?";
	      $result = ingres_unbuffered_query($link, $query, $params);
	      while ($row = ingres_fetch_row($result)) {
		  echo $row[1];
		  echo $row[2];
	      }
	      ?>

       Example #3

	      Inserting a BLOB with parameter types

	      <?php
	      $link = ingres_connect("demodb");

	      //Open a photo
	      $fh = fopen("photo.jpg","r");
	      $blob_data = stream_get_contents($fh);
	      fclose($fh);

	      //Prepare parameters
	      $params[] = $blob_data;
	      $params[] = 1201;

	      //Define parameter types
	      $param_types = "Bi";

	      $query = "update user_profile set up_image = ? where up_id = ?";
	      $result = ingres_unbuffered_query($link, $query , $params, $param_types);

	      if (ingres_errno())
	      {
		  echo ingres_errno() . "-" . ingres_error() . "
";
	      }
	      ?>

SEE ALSO

       ingres_query(3),  ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3), ingres_commit(3), ingres_roll-
       back(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3).

PHP Documentation Group 												INGRES_UNBUFFERED_QUERY(3)

Shell Programming and Scripting