5.1 Tools

< Day Day Up >

There are two basic tools for manually creating or converting stored procedures triggers, and functions: the DB2 Development Center or the DB2 Command Window. The following sections provide a brief explanation of each tool. A complete discussion of the Development Center or the Command Window can be found in Redbooks:

The Exploitation of DB2 UDB on Windows Environment, SG24-6893
DB2 UDB Evaluation Guide for Linux and Windows, SG24-6934

The Development Center

The Development Center (Figure 5-1) is a Java-based GUI tool. From the Development Center you can:

Create, build, and deploy Java and SQL stored procedures
Create, build, and deploy user-defined functions (Linux, UNIX, and Microsoft Windows operating systems):
- SQL and Java UDFs
- UDFs that read MQSeries® messages
- UDFs that access OLE DB data sources
- UDFs that extract data from XML document
Debug SQL stored procedures using the integrated debugger (Linux, UNIX, Windows and z/OS Version 8 operating systems)
Import and build structured types
Development objects contained in multiple databases at the same time
View and work with database objects such as tables, triggers, and views
Export and import routines and project information

click to expand
Figure 5-1: The Development Center

The DB2 Command Window

The DB2 Command Line Processor (CLP) behaves like a command window (Figure 5-2) from your operating system. From the DB2 Command Window you can enter operating system commands, DB2 commands, or SQL statements, and then view the output.

click to expand
Figure 5-2: The DB2 Command Window on AIX

For the deployment of our manually converted procedures and triggers, we will be using the DB2 Command Window.

Books

DB2 SQL Procedural Language for Linux, UNIX, and Windows, ISBN0131007726 (available from most online book retailers) is recommended for learning DB2 SQL PL. This book has full coverage of SQL procedures, functions, and triggers. Paul Yip, a co-author of the book, provided technical consultation and some of the material for this chapter.

The following DB2 manuals are also good sources of information:

SQL Reference, Volume 1, SC09-4844, Volume 2, SC09-4845
Application Development Guide: Programming Server Application, SC09-4827
Application Development Guide: Building and Running Application, SC09-4825
Application Development Guide: Programming Client Application, SC09-4826

< Day Day Up >