DB2 10.5 for Linux, UNIX, and Windows

Programming considerations for Perl

Perl database Interface (DBI) is an open standard application programming interface (API) that provides database access for client applications that are written in Perl. Perl DBI defines a set of functions, variables, and conventions that provide a platform-independent database interface.

You can use the IBM® DB2® database driver for Perl DBI (the DBD::DB2 driver) available from http://search.cpan.org/~ibmtordb2/ along with the Perl DBI Module available from http://search.cpan.org/~timb/ to create a Perl application that access the IBM database server.

Because Perl is an interpreted language and the Perl DBI module uses dynamic SQL, Perl is an ideal language for quickly creating and revising prototypes of DB2 applications. The Perl DBI module uses an interface that is similar to the CLI and JDBC interfaces, which makes it easy for you to port your Perl prototypes to CLI and JDBC.

The working versions of Perl that works with DB2 are Activestate Perl and 32-bit Strawberry Perl. For 32-bit Strawberry Perl specifically, you must email opendev@us.ibm.com or contact IBM support for the required binaries.

For information about supported Database servers, installation instructions, and prerequisites, see http://search.cpan.org/~ibmtordb2/