On 19 Sep 2002 at 15:10, Arvind Raina wrote: > My requirement is to execute a set of sql statements which are stored in a > file . > > I wanted to know if there is any method of doing the same using dbi .
Sure, open the file with 'open', read the commands and pass them to dbi. If you are using taint-checking (you are using taint-checking, aren't you?), then you'll need to untaint the data before passing to dbi if you are inserting data into the db (I'm not sure if other operations with tainted data will cause an error or not...). See perlsec for details on untainting. Good luck, William -- Lead Developer Knowmad Services Inc. || Internet Applications & Database Integration http://www.knowmad.com
