On Sat, Jun 01, 2002 at 10:26:42AM +0100, Poonam P wrote:
I need a script that will connect to the db and append each record to a text file till end of database. there may be simpler ways to do this, but i need a script to do this as I have further processing to do. the script can be directly executed from promtp as ./script_name
For perl script to connect to database you need a DBD (Database Driver) for that particular data base. Pearl has 2-layers between script and database. DBI, DBD layars. To provide uniform interface to all the databases DBI(Data base Interface) is defined. So you need to write code according to perl::DBI. And you don't need to change it if the database changes.
And when you get the DBD for your database use the script.
Don't know about Shell Scripts.
regards