Shell Programming and Scripting

Sure.

Step1, extract an ID and put it in the result file.
Step2, read that file and use that record to run the .sql, then delete the result file.
Step3, repeat until while cycle ends.

At the end, you'd have a report_dettaglio_date that contains every result of the .sql run. I didn't post the content of the SQL file because I thought it was not important.
There's probably some easier way to do this, but I'm still practicing.

---------- Post updated at 10:36 AM ---------- Previous update was at 09:49 AM ----------

I removed the second cycle and left with this, but still no spool. So there was no accident delete of the file.

What bothers me is that I can't even do it in some other way. I really need to spool that output in a file.
Thanks again for helping me out guys, you're the best

Code:

cat tmp_data.txt | while read line
 do 
 cdc="'$(echo $line|awk -F";" '{print $1}')'" 
emiss="'$(echo $line|awk -F";" '{print $2}')'" 
importo="'$(echo $line|awk -F";" '{print $3}')'" 
cdc_cut=$(echo $cdc | cut -c14-17) 
  sqlplus -s user/pass@SID >> result.txt << EOF 
---myQUERYhere---
; exit; EOF

done

That's a useless use of cat award. You don't need cat's help to read a file, and you don't need to run awk three times per line to extract three fields separated by ;

Why do you need it in the result file if you already have the ID? Wouldn't you rather have sqlplus' output?

Try redirecting the entire loop once instead of 1000 times for 1000 lines:

Code:

#!/bin/ksh

...

while IFS=";" read CDC EMISS IMPORTTO OTHER
do
        cdc_cut="${CDC:13:4}"
        sqlplus <<EOF
...
EOF
done < inputfile > outputfile

You might even be able to do

Code:

while IFS=";" read CDC EMISS IMPORTTO OTHER
do
        cdc_cut="${CDC:13:4}"
        cat <<EOF
...
EOF
done < inputfile | sqlplus > outputfile

to put more than one sql query into one run of sqlplus.

I've been fidgeting around that syntax a bit, and it looks like it's spooling now. I don't know how, I just altered a few things and got rid of the "Stupid use of cat" but apparently that was enough for him.

Thank you so much!

If you were using your variables outside the while-loop, cat would have prevented them from being set, because the while-loop would be run in a subshell.