Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Passing string from SQL to a BASH script
Top Forums Shell Programming and Scripting Passing string from SQL to a BASH script Post 302877977 by JonP on Wednesday 4th of December 2013 05:42:08 AM
Old 12-04-2013
Passing string from SQL to a BASH script
OS Solaris 10,
DB oracle 10g

Hello,
We currently have a BASH script that runs and moves image files from a remote server to the local db server. A snippet of the code shows that we are picking up all Images that are 'mtime -1'

Code:
some code...
for file in `ssh user@10.200.200.10 'find /u01/bea/madeup/Images -name "*.jpeg" -mtime -1'`
do
scp user@10.200.200.10:${file} /oraworking/madeup/images/orig/
done
...more code

It's simple and it works.

Now, due to development requirements we need a way of picking up those images from different directories within the base directory of /u01/bea/madeup/Images. The plan is to have an 'index' table that will hold the location (path and filename) of the image file and it is this that I would like to read from the table and somehow use in place of the hard coded file path above.
Can I Just do something like this example: (This may work with some tweaking, but it gives you an idea of what i am trying to achieve).

Code:
for file in `ssh user@10.200.200.10 'find /oracle/product/db/10gR2/bin/sqlplus -s /nolog  <<EOF  #Find is just going to try and find something in '/oracle/product/db/10gR2/bin/sqlplus' so this is wrong!

conn / as sysdba

set heading off
set feedback off
set pagesize 0
set linesize 30000
set trimout on
SELECT f.file_path||'/'||f.file_name
FROM fileupload f
INNER JOIN imagelog i
ON f.id = i.fileupload_id;'

EOF`

do
if [ -f ${file} ]
then
        echo "Skipping $file file..."
continue
fi

scp user@10.200.200.10:${file} /oraworking/madeup/images/orig/

done
...more code

Thanks in Advance,

Jonathan
Last edited by JonP; 12-04-2013 at 07:05 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing parameter from Shell-script to Sql-script

Dear Friends, Please help me to achieve the following: I want to pass one parameter from Shell-script to Sql-script. Example: My ShellScript.sh is calling report.sql like this: /bin/sqlplus /reports.sql And My report.sql is calling many Stored-Procedures like this: exec... (0 Replies)
Discussion started by: subodhbansal
0 Replies

2. Shell Programming and Scripting

Passing argumnets from shell script to sql

hi I all , I have sql statment in my shell script , I pass two argument to the script I need to pass the this two arguments to the sql statment example : runsql.sh "1" "2" sql : updat tables_x set y=0 where A=:x should subsituted by "1" and B=:y shuold subsituted bt "2"... (1 Reply)
Discussion started by: habuzahra
1 Replies

3. Shell Programming and Scripting

passing values from sql to shell script

Hi guyz, Posting a thread after a long time. I want to pass two variables to unix shell script from sql script. Note: I am calling sql script from unix script. sql script has 2 variables one is the return code for status of program run and second one email flag. I don't know how to capture... (3 Replies)
Discussion started by: sachin.gangadha
3 Replies

4. Shell Programming and Scripting

passing variable from bash to perl from bash script

Hi All, I need to pass a variable to perl script from bash script, where in perl i am using if condition. Here is the cmd what i am using in perl FROM_DATE="06/05/2008" TO_DATE="07/05/2008" "perl -ne ' print if ( $_ >="$FROM_DATE" && $_ <= "$TO_DATE" ) ' filename" filename has... (10 Replies)
Discussion started by: arsidh
10 Replies

5. Shell Programming and Scripting

Problem in Passing sql query for a script

Unix prompt ========= echo "Enter the query" read q ========== User has entered : SELECT * FROM employee ===================== Now the problem starts.. echo $q Output: SELECT "all files names in the PWD" FROM employee ================================================ ... (5 Replies)
Discussion started by: Niroj
5 Replies

6. Shell Programming and Scripting

passing arguments to sql script

Hi Gurus, i have one requirement in unix script, i have a file called abc.txt in that few lines are there with the empid, i need to read each line and pass to .sql script. ex: abc.txt 2345 2346 1243 1234 i need to pass these arguments to .sql script rom unix ex: select * from... (1 Reply)
Discussion started by: Devendar
1 Replies

7. Shell Programming and Scripting

Passing a string variable from Unix to Sql Plus

Hi Guys, I am trying to pass a string variable from Unix shell script to sqlplus as a parameter. I have tried using single quotes with the variable name but it does not work. Please help me with it. I am using BASH. My code: Your help is much appreciated. Thanks, shil (2 Replies)
Discussion started by: infintenumbers
2 Replies

8. Shell Programming and Scripting

Passing string as variable(s) in bash

I'm trying to write a basic bash script that takes input you give (what directory, if any, what name, if any ....) and passes the information to find. I'm trying to just create a string with all variables and then pass it to find. So far I have this extremely simple: #!/bin/bash -f ... (2 Replies)
Discussion started by: Starting_Leaf
2 Replies

9. Shell Programming and Scripting

Passing variable from file to sql from script

Hi Friend, I have one file in which some number are mentioned and number of lines are vary every time And i need to pass that number to my sql command from script. Suppose i have file acc.txt 45456546456 45464564565 67854353454 67657612132 Number of records are vary every time.... (20 Replies)
Discussion started by: pallvi_mahajan
20 Replies

10. Shell Programming and Scripting

Passing string from bash to sqlplus

Hello, I have file (PARFILE) with string on first line: INCLUDE=SCHEMA:"IN\( 'SCHEMA1','SCHEMA2','SCHEMA3' \)"In .sh script I use: .... IMPORT_SCHEMA=`awk 'NR==1{print $2}' ${PARFILE}` ...print $2 is because 'SCHEMA1','SCHEMA2','SCHEMA3' is 2nd column in file echo "$IMPORT_SCHEMA"... (5 Replies)
Discussion started by: DjukaZg
5 Replies

LEARN ABOUT DEBIAN

allocrdswin

ALLOCRDSWIN(3)						      RDS PHYSICAL FUNCTIONS						    ALLOCRDSWIN(3)

NAME

       allocrdswin - allocates window's table

ORIGIN

       This  software  belongs	to  the  ALLIANCE CAD SYSTEM developed by the ASIM team at LIP6 laboratory of Universite Pierre et Marie CURIE, in
       Paris, France.

       Web : http://asim.lip6.fr/recherche/alliance/
       E-mail : alliance-users@asim.lip6.fr

SYNOPSYS

       #include "rwinnn.h"
	rdswin_list *allocrdswin( Number )
	   unsigned int Number;

PARAMETER

       Number		   Number of windows contained in the window's table.

DESCRIPTION

       The allocrdswin allocates a window's table. The number of windows is specified by the parameter 'Number' of the function. To determine  the
       size of the parameter 'Number', the user has to multiplicate width by height of his table in number of windows. Each item of the table is a
       pointer to a rdswin_list structure which contains rectangles sorted by layer (see librwi).

RETURN VALUE

       The pointer to the table is returned.

ERRORS

       "Rds202: rdsalloc error, can't continue !"
	      it's impossible to allocate the memory size for the table

EXAMPLE

	       #include "mutnnn.h"
	       #include "rdsnnn.h"
	       #include "rwinnn.h"
	       #include "rtlnnn.h"
	       main()
		 {
		   rdswindow *RdsWindow;
		   RdsWindow = allocrdswindow();
		   RdsWindow->XMIN = -200;
		   RdsWindow->YMIN = -200;
		   RdsWindow->XMAX =  200;
		   RdsWindow->YMAX =  200;
		   RdsWindow->DX   =  4;
		   RdsWindow->DY   =  4;
		   RdsWindow->SIDE =  100;
		   RdsWindow->SIZE =  RdsWindow->DX * RdsWindow->DY ;
		   RdsWindow->WINTAB = allocrdswin( RdsWindow->SIZE );
		   . . .
		 }

SEE ALSO

       librwi

BUG REPORT

       This tool is under development at the ASIM department of the LIP6 laboratory.
       We need your feedback to improve documentation and tools.

ASIM
/LIP6							  October 1, 1997						    ALLOCRDSWIN(3)
All times are GMT -4. The time now is 07:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy