Shell Programming and Scripting

Hi

I have some 200 tables and I have macro which actually returns the tables columns descriptions . Say for exapmle describe('table1') will list all the columns of table one with the description.

Now what I want to do is I want to write a shell script which will take tables name from a file and will execute the macro and redirect the output into file .
I will take care the database connection part and extraction just tell me how write that script where it will take table name from a file one by one ????

file1 contains all table names

Code:

#!/usr/bin/ksh

while read tablename
do

   echo "describe('$tablename')"

done < file1

Redirect the output to a file

You get the file with all desribe macro of all tables