 | Level: Introductory Debra R. Eaton (deaton@us.ibm.com), DB2 Software Information Technology Specialist, IBM
15 Dec 2005 The IBM® DB2® Universal Database™ (UDB) plug-ins for Rational® Application Developer give developers the ability to connect, browse and alter DB2 databases. In this tutorial learn how the Rational Application Development perspectives, views and wizards assist you with defining and working with database object DDL such as schemas and tables. Learn how to create, execute and edit DML statements such as SELECTs and INSERTS. Create, execute, run, and debug DB2 stored procedures with the Rational Data and Debug perspectives.
In this tutorial This tutorial demonstrates the steps: - To create DDL statements
- To deploy database objects
- To create and execute DML statements
- And to create, execute, and debug stored procedure routines using the Rational® Application Developer (RAD) Data and Debug perspectives.
Objectives - In this tutorial, you learn about the RAD Data perspective, Debug perspective, Data Definition view, Database Explorer view, and the DB Output view. Step-by-step instructions give you hands-on experience in using the perspectives, views, and wizards.
Prerequisites This tutorial is written for DB2 database developers, DB2 database administrators, and Rational developers whose skills using RAD for DB2 database development are at a beginning to intermediate level. You should have a general familiarity with database objects and working with a GUI interface.
System requirements This tutorial was created with trial versions of Rational Application Developer (RAD) V6.0 and DB2 UDB V8.2 running on Windows XP®. See resources for download information. The tutorial was written from the viewpoint of a new installation of the Rational software. The assumption is that all settings, views, and perspectives are set to the RAD default configuration. We will use the DB2 SAMPLE database. The operating system userid and password is used to gain access to DB2.
Duration 3 hours
Formats html, pdf
| | | |
