How to Create Table from Parameter File?

[Sturdevant, Robert W. (Contr)]

Hi all,

I'm just starting a project moving legacy DOS ISAM data to a new Windows NT
MySQL database. My first effort with both MySQL and DBI. I've written a Perl
script to parse the old ISAM definition files and create command files to
create and load new DB tables with matching characteristics.

All works fine in batch mode from a command console (eg, c:\mysql\bin\mysql
< CommandFile ). Also works fine as 'mysql> source CommandFile'. But there
must be a way to do this thru the DBI API. I've tried the obviuos $dbh->do(
"source PerlScript" ) and everything else I can think of. Perl always
complains about syntax, even tho the command file runs from the NT console.

In short, I'd like to do something like, if possible:

CREATE TABLE name( $FileName );

Regards,
Bob