1. | With the Development Center, you can create, build, run, and deploy stored procedures on a DB2 database server. Use the Create SQL Stored Procedure wizard to create an SQL stored procedure. |
![]()
![]()
![]()
![]()
2. | Using the wizard, you can name the stored procedure, define the structure, and specify the parameters and additional options. You can also customize the generated source code by specifying files that contain specific code fragments. |
3. | After you create the stored procedure, you can build it. When you build an SQL stored procedure, the Development Center compiles the source code on the server, copies the source code to the DB2 server, and registers the stored procedure in the catalog table. View results in the Output View. |
4. | After you build the stored procedure, you can run it for testing purposes. When you run the stored procedure, you can determine whether the run is successful and whether a result set exists. Running a stored procedure also helps you to test the logic of the stored procedures and the accuracy of output arguments and result sets. View results in the Output View. |
5. | Finally, you can use the Deployment wizard to deploy a stored procedure to a target database. Using the wizard, you can select the target database, select the stored procedure you want to deploy, and specify deployment and error handling options. |
) to start the animation.
) to continue to the next animation.
) to start the animation.
) to go to the previous animation.