Transactions No Locking Implicit, per-statement only Table joins No LONG/LOB datatypes Yes, up to 4 GB Statement handle attributes available After execute( ) Placeholders Yes, "?" style Stored procedures No Bind output values No Table name letter case Sensitive, partly depends on filesystem Field name letter case Sensitive, stored with original letter case Quoting of otherwise invalid names No Case-insensitive "LIKE" operator Yes, "CLIKE" Server table ROW ID pseudocolumn No Positioned update/delete No Concurrent use of multiple handles Unrestricted
The driver author is Jochen Wiedmann. He can be contacted via the dbi-users mailing list.
DBD::CSV driver is built upon the services of
several other related modules. The
module is used for reading and writing
CSV files. The abstract generic
provides the driver framework for handling flat files. That, in turn, uses the
SQL::Statement module to parse and evaluate simple
It’s important to note that while just about everyone thinks they know what the CSV file format is, there is actually no formal definition of the format, and there are many subtle differences.
Here’s one description of a CSV file:
DBD::CSV does not fully parse the statement until it’s executed. Thus, ...