Shell Programming and Scripting

Hi experts .
i have a script which will take parameters from a text file.
but now i need a script which will take 2 parameters from 2 different files or from a Excel sheet from 2 different columns.

i have the script as follows (which will take parameter from a txt file).

#/bin/sh
k="username"
p="password"
d="DB"
echo "executing sql query"
while read source
do
sqlplus -s $k/$p@$d <<EOI>>output.txt
set serveroutput on
set heading off
set linesize 200
set trimspool on
set echo off
set markup HTML off
set feedback off
set termout off
set pagesize 250
set verify off
set pages 1000
select * from Table where columnn like '%$source%');
EOI
done<input.txt
echo "COMPLETED"


Now i want a script which will read 2 parameters from different files.

Thanks Mohan

Post file sample and required data.

build a combined parameter file in a separate loop, then loop thru the "combined" file for your sql.

hi danmero..
actually i am trying to create a script which will move all the files from Old server to new server.(2 different servers)
i have 2 files (old_paths.txt and new_paths.txt)
For each old path in old_path.txt there is a corresponding new path mentioned in the new_path.txt. (both the files contain absolute paths)
My script should take parameter from both the text files... and move all the files from old to new server ... the script which i have in my mind is something like as follows : (which i will run in new server)



#/bin/sh
USER="user"
PASS="password"
ftp -n $HOST <<END_SCRIPT
quote USER $USER
quote PASS $PASS
echo "copying the Files"
#echo "----------------------------"#
while read parameter1 parameter2 ------ this line is wrong
do
lcd $parameter1 ------ this line is wrong
cd $parameter2 ------ this line is wrong
mget *.*
EOI
done<input.txt
quit
END_SCRIPT
echo "COMPLETED"

ok, so assuming there is a 1:1 correspondence betw. lines in each file, i.e.,

Code:

file1:      file2:
dir1        dir1a
dir2        dir2a

you can paste these together into a param file

Code:

paste file1 file2 > combined

then you can iterate over that to populate an ftp macdef.

or if you can use sftp, you could instead put the contents of 'paste' into a var and iterate over the var to create a command batch file, and feed that to 'sftp -b [batchfile]'

by using a variable and then feeding that to a loop, you'll get alternating lines from each file:

Code:

COMBINED=`paste file1 file2`
COUNT=1
for each in $COMBINED
do
   if [ $COUNT % 2 ]
   then
     echo "cd $each" >> batch
     echo "mget *.*" >> batch
   else
     echo "lcd $each" >> batch
   fi
   COUNT=`expr $COUNT + 1`   
done