If dynamic SQL does not have parameter markers (placeholders), it could be immediately executed after that step.
Listing 8 shows the syntax for the Now let's see how to execute an SQL statement which is unknown at the time the application is written and has parameter markers or placeholders; that is, a truly dynamic SQL statement.
You'll find the main DBD:: DB2 (this is the naming technique within the Perl language) driver information page at
Perl — Practical Extraction and Report Language -- is a powerful and easy-to-use programming language available for many operating systems. You can download the language (in source code or binary form) and use it without paying a license fee. It contains aspects of the C programming language, as well as UNIX® commands such as .
An interpreted language, Perl can be used in stand-alone applications or with Apache to build Web applications.
DBD:: DB2 is a Perl module which, when used in conjunction with DBI, allows Perl to communicate with DB2 UDB.
So, in the order to run a Perl script that has access to your DB2 database, you need the following components on your system: You can find all installation and configuration instructions on the Web site.