IBM DB2 Application Development Guide

From IBM

This book discusses how to design and code application programs that access DB2 databases and application servers. It presents detailed information on the use of Structured Query Language (SQL) in supported host language programs. For information unique to your specific operating system, see the Application Building Guide.

You can access data with:

1. SQL statements embedded in a host language, including embedded SQL for Java (SQLJ)
2. dynamic APIs including Java Database Connectivity (JDBC), Perl DBI, and DB2 Call Level Interface (DB2 CLI)

This book discusses all these ways to access data except DB2 CLI, which is discussed in the CLI Guide and Reference. JDBC, SQLJ, and DB2 CLI provide some data access capabilities that are not available through embedded SQL. These capabilities include scrollable cursors and stored procedures that return multiple result sets. See the discussion in Access to Data to help you decide which data access method to use.

To effectively utilize the information in this book to design, write, and test your DB2 application programs, you need to refer to the SQL Reference along with this book. If you are using the DB2 Call Level Interface (CLI) or Open Database Connectivity (ODBC) interface in your applications to access DB2 databases, refer to the CLI Guide and Reference. To perform database manager administration functions using the DB2 adminstration APIs in your application programs, refer to the Administrative API Reference.

You can also develop applications where one part of the application runs on the client and another part runs on the server. Version 6 of DB2 introduces support for stored procedures with enhanced portability and scalability across platforms. Stored procedures are discussed in Stored Procedures...........

Click to Read More