perl操作DB2数据库的环境准备

Compiling the DBD :: DB2 module on Linux or UNIX

To build and install the DBD::DB2 module, you need the following:

• Perl 5.005_03 or later
• DB2 Application Development Client
• A supported C compiler as documented under 'Supported operating systems' on the Application development Web page.

1. Set the DB2_HOME environment variable to the location of your DB2 instance. For example:bash# export DB2_HOME=/home/db2inst1/sqllib
2. Install the DBI module:bash# perl -MCPAN -e 'install DBI'
3. Install the DBD::DB2 module:bash# perl -MCPAN -e 'install DBD::DB2'

Installing DBD::DB2 with ActivePerl on Windows

If you are using the Perl distribution on Windows, you can install a binary version of the DBI and DBD::DB2 modules.

Prerequisites:

• ActivePerl 5.8 or later
• DB2 client, Version 8.1 or later

For example, if you have ActivePerl 5.8.7 installed, you can install the DBD::DB2 modules as follows:

• Install the DBI module by issuing the following command (the DBI module is a prerequisite for the DBD::DB2 module): ppm install DBI
• Install the DBD::DB2 module by issuing the following command: ppm install
• To uninstall the DBD-DB2 module, issue: ppm uninstall DBD-DB2

When the DBD::DB2 module is successfully installed, you can access documentation and a sample application by issuing the following command: