DB2 10.5 for Linux, UNIX, and Windows

Creating Java routines

Creating Java™ routines consists of executing a CREATE statement that defines the routine in a database server, and developing the routine implementation that corresponds to the routine definition.

Before you begin

Review Java routines.
Ensure that you have access to a database server, including instances and databases.
Ensure that the operating system is at a version level that is supported by the database products.
Ensure that the Java development software is at a version level that is supported for Java routine development. Refer to Supported Java routine development software.
Ensure a valid Specification of a driver for Java routines development.
Authority to execute the CREATE PROCEDURE or CREATE FUNCTION statement.

For a list of restrictions associated with Java routines see:

Restrictions on Java routines

About this task

The ways in which you can create Java routines follow:

Using IBM® Data Studio
Using IBM IBM Data Studio
Using the database routine development features in IBM Rational® Application Developer
Using the DB2® command window

In general it is easiest to create Java routines using the IBM Data Studio, although many developers enjoy the ability to create Java routines from within the integrated Java development environment provided by IBM Rational Application Developer. If these graphical tools are not available for use, the DB2 command window provides similar support through a command line interface.

Create Java routines using one of the following procedures:

Procedure

Creating Java routines using IBM Data Studio
Creating Java routines using Rational Application Developer
Creating Java routines from the command line