Define an external procedure

If you want to call a program as a procedure from an SQL program, you must first define the program as an external procedure. The program for which a procedure is defined does not need to exist at the time the procedure is defined. In order to define a program as an external procedure:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Right-click the Functions container and select New, then External.

To define your external procedure on the New External Procedure dialog, use the following steps for the tabs.