How do I run a stored procedure in DB2?

How do you execute a stored procedure?

Expand the database that you want, expand Programmability, and then expand Stored Procedures. Right-click the user-defined stored procedure that you want and select Execute Stored Procedure. In the Execute Procedure dialog box, specify a value for each parameter and whether it should pass a null value.

How do you execute a stored procedure from the command line?

To use the CALL statement, enter the stored procedure name plus any IN or INOUT parameter values and a place-holder ('? ') for each OUT parameter values. The parameters for a stored procedure are defined in the CREATE PROCEDURE statement for the stored procedure.

Does DB2 support stored procedures?

Db2 provides some stored procedures, but you can also create your own. A stored procedure provides a common piece of code that is written only once and is maintained in a single instance that can be called from several different applications.

How do I view a stored procedure in IBM DB2?

To view the code of a stored procedure, perform any of the following options. In the left pane of the screen that is displayed, expand the All Databases group and select the appropriate database to expand its objects tree, then select Application Objects, Stored Procedures.