Does anyone know why the following fails with:
"SQL ERROR: 'DATE' is not a recognized data type!" ?
I cannot seem to find valid data types.
use DBD::CSV;
use DBI;
my $table = "csvtest";
my $dbh = DBI->connect("DBI:CSV:f_dir=/home/lsturtz/perl/")
or die "Cannot connect: " . $DBI::errstr;
my $sth = $dbh->prepare("CREATE TABLE $table (symname CHAR(10), level
REAL(10,2), obvdate DATE )")
or die "Cannot prepare: " . $dbh->errstr();
$sth->execute() or die "Cannot execute: " . $sth->errstr();
.
.
.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com