Trying to use FOR loop variable to create files but failed, plz help

intikhabalam · 07-15-2008, 06:51 AM

for myvar in $(cat $filename)
do
sqlplus -s a/a@b @GetPatchItemsQry.sql $myvar
done > tmpPatchItemsqry"$myvar"a.sql

here i want to create the multiple files, means, one file with one myvar variable value but programme create only one file with

tmpPatchItemsqry"$myvar"a.sql

name.

Plz help

trickykid · 07-15-2008, 07:00 AM

Well, you have $filename in the beginning.. what is it's value since it's defined as a variable?

chrism01 · 07-15-2008, 09:46 PM

Also, shouldn't it be

Code:

for myvar in $(cat $filename)
do
sqlplus -s a/a@b @GetPatchItemsQry.sql $myvar >tmpPatchItemsqry${myvar}a.sql
done

intikhabalam · 07-16-2008, 01:00 AM

Quote:

Originally Posted by trickykid

Well, you have $filename in the beginning.. what is it's value since it's defined as a variable?

That contain the file name, Actually in this script i am downloading the files from DIMENSIONS server using BASELINE name, This script will get the BASELINE name from CSV file then connect to DIMENSIONS server and get the File names and path.

This CSV file contains more than one BASELINES now i want that, this script will generate Filenames and paths for one BASELINE in one file. This script is generating the FILENAMES and PATHS correctly but does not generate multiple files. now plz send me an example , how to create multiple files in a loop. thanks in advance.

trickykid · 07-16-2008, 01:28 AM

Well, can you post the other script or scripts so we can see where the problem is?