Oracle to DB2 UDB Conversion Guide2003

5.1 Tools

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

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.

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