how to use data in unix text file as input to an sql query from shell

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET...

2. UNIX for Dummies Questions & Answers

Inserting shell script input data automatically from a text file

Dear experts, I am new to linux programming. I have a shell script which i should run it on all my samples. I only define input and out put for this script. The inputs are 3 numbers(coordination numbers) which are available in a series of text file. Since i have a lots of samples, it takes a...

3. Shell Programming and Scripting

Read input file and used it to SQL query

Hi All, Seeking for your assistance to read each line $1 and $2 of input file and used it to query. Ex. file1.txt(number range) 9064500000 9064599999 9064600000 9064699999 9064700000 9064799999 Database name: ranges_log a_no message 9064500001 test 9064700000 ...

4. Shell Programming and Scripting

Shell scripting unable to send the sql query data in table in body of email

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email. spool table_update.html; SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription'; spool off; exit; Please use code tags next time for your code and data....

5. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required.

6. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

7. Shell Programming and Scripting

Need help to run sql query from a script..which takes input from a file

I need to run sql script from shell script which takes the input from a file and contents of file will be like : 12345 34567 78657 and query will be like : select seq_nbr from bus_event where event_nbr='12345'; select seq_nbr from bus_event where event_nbr='34567'; select seq_nbr...

8. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

9. UNIX for Dummies Questions & Answers

How do I use SQL to query based off file data?

This is basically what I want to do: I have a file that contains single lines of IDs. I want to query the oracle database using these IDs to get a count of which ones match a certain condition. the basic idea is: cat myfile | while read id do $id in select count(PC.ptcpnt_id) from...

10. UNIX for Dummies Questions & Answers

sql query results in unix shell script

Hi I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this. 1. Opened a cursor to a table in DB2 databse. 2. Fetching individual rows with the help of cursor. 3. Each row has 4 fields. I want each of the field in individual shell...

LEARN ABOUT PHP

mysql_db_query

MYSQL_DB_QUERY(3)							 1							 MYSQL_DB_QUERY(3)

mysql_db_query - Selects a database and executes a query on it

SYNOPSIS

       Warning

	      This  function  was deprecated in PHP 5.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
	      sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide  and  related  FAQ  for  more
	      information. Alternatives to this function include:

		     omysqli_select_db(3) then the query

		     o PDO::__construct

       resource mysql_db_query (string	$database, string  $query, [resource  $link_identifier = NULL])

DESCRIPTION

       mysql_db_query(3) selects a database, and executes a query on it.

	      o $database
		- The name of the database that will be selected.

	      o $query
		- The MySQL query.  Data inside the query should be properly escaped.

	      o $
		link_identifier  -The  MySQL  connection.  If  the  link  identifier is not specified, the last link opened by mysql_connect(3) is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	Returns a positive MySQL result resource to the query result, or FALSE on error. The function also returns TRUE/ FALSE for INSERT/ UPDATE/
       DELETE queries to indicate success/failure.

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.3.0	|						    |
       |	|						    |
       |	|  This function now throws an E_DEPRECATED notice. |
       |	|						    |
       +--------+---------------------------------------------------+
       Example #1

	      mysql_db_query(3) alternative example

	      <?php

	      if (!$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
		  echo 'Could not connect to mysql';
		  exit;
	      }

	      if (!mysql_select_db('mysql_dbname', $link)) {
		  echo 'Could not select database';
		  exit;
	      }

	      $sql    = 'SELECT foo FROM bar WHERE id = 42';
	      $result = mysql_query($sql, $link);

	      if (!$result) {
		  echo "DB Error, could not query the database
";
		  echo 'MySQL Error: ' . mysql_error();
		  exit;
	      }

	      while ($row = mysql_fetch_assoc($result)) {
		  echo $row['foo'];
	      }

	      mysql_free_result($result);

	      ?>

       Note

	       Be aware that this function does NOT switch back to the database you were connected before. In other  words,  you  can't  use  this
	      function	to  temporarily run a sql query on another database, you would have to manually switch back. Users are strongly encouraged
	      to use the database.table syntax in their sql queries or mysql_select_db(3) instead of this function.

       mysql_query(3), mysql_select_db(3).

PHP Documentation Group 													 MYSQL_DB_QUERY(3)

Shell Programming and Scripting