How do I view a stored procedure in IBM DB2?

Question

DB2 stores the system related tables under syscat schema. So a query on syscat.routines will give you the Stored Procedure content. Using the db2 describe command, you can see the table schema and can determine which all columns you want to view. 4 авг. 2010 г.

How do I view stored procedures?

You can find the stored procedure in the Object Explorer, under Programmability > Stored Procedures as shown in the following picture: Sometimes, you need to click the Refresh button to manually update the database objects in the Object Explorer.

How do I view stored procedures in database?

First, run SQL Server Management Studio and connect to the Database Engine. Next, under Object Explorer, expand the database in which you have created a procedure, and then expand “Programmability” option. Next, expand “Stored Procedures”, right-click the procedure you want and then select “View Dependencies” option.

How do I view a stored procedure in IBM Data Studio?

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.

Where is stored procedure stored in DB2?

A stored procedure is a compiled program that can execute SQL statements and is stored at a local or remote Db2 server. You can invoke a stored procedure from an application program or from the command line processor.

Expert · Answer