Home

 

Introduction

Rational Application Developer provides rich features to make it easier to work with tables, views, and filters; create and work with SQL statements; create and work with database routines (such as stored procedures and user-defined functions); and create and work with SQLJ files. You can also create, modify, and generate data models. Depending on your goals, you might have to take certain steps to set up your work environment.

Depending on your goals, this chapter is written for three types of users:

To access databases and discover information about them, you can use the database explorer to create a connection to those databases. After you have set up connection information for a database, you can connect, refresh a connection, and browse the objects that are contained in the database.

To develop database related activities such as SQL queries and stored procedures, you have to create a data development project. The data development project stores your routines and other data development objects. Application developer also provides tooling to assist you to develop SQLJ applications, and offers a DB beans package to access database information without directly using the JDBC interface.

To design your database model, you have to create a data design project to store your objects. The modeling tool assists you to build a data model, analyze the model, perform the impact analysis, and so forth.

All examples in this chapter are demonstrated against the open source embedded Derby database server. The embedded version of Derby is bundled inside Rational Application Developer, so its availability is guaranteed. These examples can be easily applied to DB2 databases.

ibm.com/redbooks