This is the process for building a stored procedure.
Before you begin
Before
a stored procedure can be invoked from the Database Explorer view
or any other calling program, it must be built on the remote system.
Procedure
- Right-click the stored procedure in the Data Project Explorer
and select Build. The build utility
is now invoked on the remote system and builds the executable form
of the stored procedure. This process includes the compilation of
the source code, the linkage of the load module, the binding of the DB2® package and the registration
of the stored procedure in the DB2 catalog.
The
build process is displayed in the Data Output tab with the status
“In progress” until it is completed.
The status in the Data
Output tab changes to "Success" or "Failure" when the build process
is completed. When execution is successful, a short summary of the
build process is displayed.
If the build process was not successful,
information about the failure will be displayed in the Data Output
tab.
- Once the stored procedure has been built on the remote
system and refreshed, it will appear in the Database Explorer view.
To refresh, right-click on the Stored Procedures folder in the Database
Explorer view and select Refresh. Wait until
the refresh has been completed. The stored procedure
will appear in the Stored Procedures folder of the Database Explorer
view after the connection has been refreshed.