#!/sw/perl5/1.1/bin/perl
use strict;


my $filename = "MyFileName0000";

local $/ = "\n\n";
my $temp_line;
my $filehandle;


open ( INFILE, $filename ) ||
    ( die "Cant read $filename: $!");


while ( <INFILE> ) {
    chomp;
    ++$filename;
    print "**** Open file $filename here\n";
    open ( IFILE, ">>$filename" );

    print IFILE "$_\n";
    close(IFILE);
    print "**** Close file $filename here\n";
}

select INFILE;
close(INFILE);


##</code><code>##

#!/sw/perl5/1.1/bin/perl
use strict;

my $filename = "MyFileName0000";

local $/ = "\n\n";
my $scriptname;
my $filehandle;

open ( INFILE, $filename ) ||
    ( die "Cant read $filename: $!");

while (<INFILE> ) {
    chomp;
  #++$filename;
$scriptname=~ /CREATE TABLE ([\S]*)/;
   print "**** Open file $scriptname here\n";
    open ( IFILE, ">>$scriptname" );
    print IFILE "$_\n";
    close(IFILE);
    print "**** Close file $scriptname here\n";


}
select INFILE;
close(INFILE);