This is the process for building a stored procedure.
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.
- Right-click the stored procedure in the Data Project Explorer
and select Build 390 Stored Procedure. 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.