The Editor view is used to display and edit the source
code and the definitions of a stored procedure.
There are seven tabs at the bottom of the Stored Procedures Editor
view frame. Select a tab to open one of the following pages:
- The Overview page provides general information about a stored
procedure, such as the name and the schema.
- The Parameters page shows the input and output parameters of a
stored procedure.
- The Options page shows the characteristics of a stored procedure,
which can be specified in the CREATE PROCEDURE statement. Some of
the options can be modified and the changes are propagated to the
CREATE PROCEDURE on the DDL page.
- The Deploy page shows the name of the build utility and the options
that are used in the build process.
- The DDL page shows the CREATE PROCEDURE statement, which is used
in the build process to define the stored procedure in DB2®.
- The Data sets for Deploy page lists the data sets used during
the build process. Among these data sets are the database request
module, compiler listing, object deck, load module, and copy library
data sets.
- The Source page shows the source code of the stored procedure
and is used to create and change the source code.
Source code for
the stored procedure is also changed or updated automatically if you
change the fields on other pages, such as the Deploy page, DDL page,
or other pages.