[Phoenix-pm] Running a SQL program within PERL DBI

[Corey Saltiel]

On Wednesday March 15 2006 2:18 pm, Loo, Peter # PHX wrote:
> 
<snip>
> My goal is to have a generic PERL sub_routine that I can pass one to
> many arguments (including the sql file name) and have it perform the SQL
> statement that is within the sql file dynamically so that we can reuse
> the same sub_routine for all select statement sql files.  Does that make
> sense?  I am all for reusing of code and not reinvent the wheel 
>

SQL::Abstract

http://search.cpan.org/dist/SQL-Abstract/lib/SQL/Abstract.pm

Your "sql files" can/should become proper modules; coupled w/ SQL::Abstract,
you'll get what you're looking for.


Beers,

Corey