Error in while loop

Shell Programming and Scripting
1

I have a file Table.out having table name like this

Table_Emp
Table_Exp
Table_Fcr

To show first 10 rows .. I' wrtng a script like this ..

#!/bin/ksh

cat /tmp/table.out|while read -r table vbar1 
do 
<connect to db>
then
select * from $table limit 10; > /tmp/1.out
done
 
[/CODE
 
Plz help ..But This is resulting in error like this 
 
ERROR:  'select * from  limit 1;'
error                   ^ found "LIMIT" (at char 16) expecting an identifier found a keyword
2

Your code tags are destroyed.

What does the quoting in your <connect ... limit 10; code snippet look like?

3

Rudic

]#!/bin/ksh

cat /tmp/table.out|while read -r table vbar1 
do 
<connect to db>
then
select * from $table limit 10; > /tmp/1.out
done
4

It certainly is NOT <connect to db> verbatim! What about the quoting therein?