IBM DB2 Application Development Guide

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

DB2 Java Stored Procedures

DB2 Java Stored Procedures

Learning by Example

By Maria Sueli Almeida, Kirk Condon, Michael Fischer and Julian Stuhler

Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. The DB2 Family of products has offered support for stored procedures for some time, with each release offering significant enhancements over the last.

In the meantime, Java has been making steady inroads as the standard application development language for many companies large and small. Its inherent portability and openness, combined with the good availability of skilled programming resource, has made it an increasingly attractive choice, and the central plank in many organization’s e-business strategy.

Until recently, DB2 did not support stored procedures written in Java, so the advantages of the two technologies could not be combined. The latest releases of DB2 have changed all that, opening up new possibilities for efficient, secure, highly portable application development.

This IBM Redbook aims to give the reader an in-depth understanding of the techniques and issues associated with the development of DB2 stored procedures written in Java and using SQLJ and/or JDBC for their SQL operations. The extensive collection of sample code presented in this book and included on the accompanying CD-ROM was designed to run against DB2 UDB Server across the OS/390, Windows, and UNIX platforms.

We have assumed that the reader has at least a basic understanding of Java terminology (such as classes, methods and packages) in addition to exposure to general DB2 application development concepts.

Click to Read More