sub getsql{ my $dbh = shift; my $script = shift; my $insert= shift; local $/ = undef; open FILE, '<', $script, or die "Couldn't open SQL file"; my $insql = dwindex(); my $outsql; if (length $insert) { $outsql = getinserts($insql,$insert); } else { print "in else:$insql\n"; if ($insql =~ m/.*~\w+~.*/) {print "MATCHED IT\n";} errmsg(1) && die if ($insql =~ m/.*~\w+~.*/); print "pased*********************\n"; $outsql = $insql; } close FILE; return $outsql; }