Shell Script Basic

[jaiser roney]

Hi ,

i am working in a file #!/bin/sh


when i use below for loop its working fine , the value in $FORM_form_id_numbers is as 1234ad,45466,7890 and i am able to get each individual value separated by comma

IFS=","
for numb in "$FORM_form_id_numbers"; do
echo $numb
done


Also after preparing below sql i am able to have contents in out.log file

$ISQL << ! > ${L}/out.log
SELECT * FROM db_outerlayer..logger WHERE number_id="wer123_4545"
go
!


My problem starts when i put my sql in the for loop , after doing so i didnt get any error's not it provide any result , and out.log is empty , permission's for the out.log is proper.


IFS=","
for numb in "$FORM_form_id_numbers"; do

$ISQL << ! > ${L}/out.log
SELECT * FROM db_outerlayer..logger WHERE number_id=$numb
go
!

done


What is the problem in the above for loop which calls this sql.

Thank you in Advance

[Sujoy Choudhury]

I think you are not appending to out.log so every time that file is getting created.
And in last execution may be nothing is written to the file.
Use >> instead to see all the output appended.