Re: Using Sybase::BCP ~ getting NULL values

[runrig]

Plugging relatively new library DBIx::BulkUtil, which is among other things a wrapper around Sybase bcp, Oracle sqlldr, and SybaseIQ "LOAD TABLE":

my ($dbh, $dbu) = DBIx::BulkUtil->syb_connect(
  Server => $server,
  Database => $database,
  User => $user,
  Password => $pw,
);

# Default is "|" column, "\n" row delimiter
$dbu->bcp_in($table, $file);

Columns in the file are assumed to be in the same order as the table, but that can be overridden.