You can use several different programming interfaces to manage or access DB2 databases. You can:
Use DB2 APIs to perform administrative functions such as backing up and restoring databases.
Embed static and dynamic SQL statements in your applications.
Code DB2 Call Level Interface (DB2 CLI) function calls in your applications to invoke dynamic SQL statements.
Develop Java™ applications and applets that call the Java Database Connectivity application programming interface (JDBC API).
Develop Microsoft® Visual Basic and Visual C++ applications that conform to Data Access Object (DAO) and Remote Data Object (RDO) specifications, and ActiveX Data Object (ADO) applications that use the OLE DB Bridge.
Develop ADO.NET applications using DB2 .NET Data Provider, OLE DB .NET Data Provider or ODBC .NET Data Provider.
Develop applications using IBM® or third-party tools such as Excel, Perl, and Open Database Connectivity (ODBC) end-user tools such as Lotus® Approach®, and its programming language, LotusScript.
Programming Considerations for Perl
Perl is a popular programming language that is freely available for many operating systems. Using the DBD::DB2 driver available from http://www.ibm.com/software/data/db2/perl with the Perl Database Interface (DBI) Module available from http://www.perl.com, you can create DB2 applications using Perl.
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 quite similar to the CLI and JDBC interfaces, which makes it easy for you to port your Perl prototypes to CLI and JDBC.
Most database vendors provide a database driver for the Perl DBI Module, which means that you can also use Perl to create applications that access data from many different database servers. For example, you can write a Perl DB2 application that connects to an Oracle database using the DBD::Oracle database driver, fetch data from the Oracle database, and insert the data into a DB2 database using the DBD::DB2 database driver.