I don't see anything wrong with your code - is the "bunches of stuff"
section too big to include?  Also include the standard versions of OS,
Perl, DBI, which database you're using and which DBD (and version of
DBD).

>>> Laurie Vien <[EMAIL PROTECTED]> 03/24/04 02:44PM >>>
I am running a very simple Perl script using DBI (skeleton of it
follows).
It does everything I expect it to, but the problem is it doesn't
finish
until I Ctrl-C, at which time I get the message "Terminating on signal
SIGINT(2)".  What have I left out or done in the wrong order that
causes it
not to terminate?:

#MyPerlScript.pl
use DBI;
use Date::Manip;

$dbh = DBI->connect($DB_CONN, $DB_USER, $DB_PASS) || die "Can't
connect:
$dbi::errstr";
open(STDOUT, ">>myfile.txt") or die "\nCould not open STDOUT: $!";

$sth = $dbh->prepare("SELECT * FROM MyTable");  
$sth->execute();

# < Do bunches of stuff here ....>
#
#

$sth->finish();
$dbh->disconnect();
close(STDOUT);

Laurie

Reply via email to