A lot has changed since DBD-CSV-0.22! That version was from April 2005.

At the moment of writing, the current versions are:

DBI-1.631
DBD::CSV-0.44
Text::CSV_XS-1.10
SQL::Statement-1.405
[download]

My first hunch would be, with your old versions, to add the schema:

my $sth = $dbh->prepare (q{select * from "root".export});
$sth->execute;
while (my $h = $dbh->fetchrow_hashref) {
    # Don't know if casing of fieldnames is sane in those versions
    # YMMV, $dbh->{FetchHashKeyName} = "NAME_lc"; might help
    print "ID: ", $h->{id}, ", SN: ", $h->{service_name};
    }
[download]

I'm running RHEL6, with the packaged PERL. So I rebuilt the latest stable PERL (v5.20.0) from source and installed the latest dependencies.

DBI-1.631
DBD::CSV-0.44
Text::CSV_XS-1.10
SQL::Statement-1.405


This seems to have done the trick. It's not ideal, since I have to maintain the source built version. I'll log a bug with Red Hat to see if they can patch it into the next update.

Thanks for you help

YEAH! Well done. ++ to your effert.

Feel free to bug us again when you have other issues.


Enjoy, Have FUN! H.Merijn