I have a SQL routine stored in a file, that I wish to run in between other SQL statements within a perl/DBI script. I wonder, besides to read that file into a "prepare" statement, is there a way to directly execute that file from within the perl script? On a second thought, the
system("mysql -u user -p pass dbname < script_file.sql"); might be one but is there more simple ways since with a perl/DBI a connection is already established? joe