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 -- Pankaj Jangid NCST, India _______________________________________________ http://mm.ilug-bom.org.in/mailman/listinfo/linuxers

