Can AWK solve it ???

emon · #1 (**permalink**) 02-23-2005

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 ????

bhargav · #2 (**permalink**) 02-23-2005

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Riddle - solve it if you can	numstr	Shell Programming and Scripting	1	08-15-2007 12:52 PM
How to solve this	akashag22	Shell Programming and Scripting	3	07-21-2007 05:54 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by