in reply to Waiting for an SQL script to finish

First of all, welcome to the Monastery, and I hope you find it both helpful and enjoyable to visit here.

Now, to your question. First of all, I would suggest using the DBI module to make connections to the database, then you can just execute the SQL commands you have (there are some articles in the Tutorials section which may also be helpful in looking at that). You can also use Net::FTP for handling the FTP connection (although it might also be possible for your to install the appropriate modules on the remote machine and run the script from there, eliminating the FTP requirement-just a thought).

HTH.

  • Comment on Re: Waiting for an SQL script to finish

Replies are listed 'Best First'.
Re: (2) Waiting for an SQL script to finish
by LeeC79 (Acolyte) on Aug 26, 2003 at 18:59 UTC
    There isn't anything I can do to just run an SQL script? Since I've already created a script file, which outputs the result set into a file, I think just running the SQL script from a Perl script would be easiest. ??