Basic Program Flow

The program flow for accessing DB2 and retrieving data from the database is similar to that of CLI (shown in Figure 13.1). There is still an initialization phase, transaction processing phase, and a disconnecting and termination phase. These phases take on a slightly different form than that of CLI because the DBI methods encapsulate much of the initialization and termination phases for you.

Figure 13.1. Basic program flow.

The Perl DBI module supports only dynamic SQL. When you need to execute a statement multiple times, you can improve the performance of your Perl DB2 applications by issuing a prepare call to prepare the statement. ...

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.