quotation mark use

UNIX for Advanced & Expert Users
1

Hi colleagues,

I am development a script.

this flat file pp.txt contain this tree lines.

prueba
prueba1
prueba2

cat pp.txt |awk '{print a}' |while read a
do
  var=`db2 select count(*) from $a`"
  echo $var
done

executing var show me error.

I need var contain: db2 "select count(*) from prueba;"

any help is very appreciate.

Thank you for advanced.

2 
while read a
do
  var=$(db2 "select count(*) from $a")
  echo "$var"
done < pp.txt