How to check which tables a stored procedure is using i…

1 year ago
Liam
2 minutes

To view the tables used in a stored procedure, you can use the following method:

  1. Utilize the Command Line Interface (CLI):
  2. Enter the following command in the command line interface:
  3. Retrieve the table name from the SYSIBM.SYSTABLES where the stored procedure name matches the dependency table name and the dependency type is ‘F’.
  4. Replace the stored procedure name with the stored procedure name you want to query. After running this command, the names of the tables used by the stored procedure will be displayed.
  5. Use the DB2 Control Center:
  6. DB2 Control Center is a graphical interface tool that makes it easy to manage and operate DB2 databases. With DB2 Control Center, you can view the tables used by stored procedures using the following steps:
  7. Open the DB2 Control Center and connect to the appropriate database.
  8. Expand the database node on the left panel and then expand the “stored procedures” node.
  9. Navigate to the “Stored Procedures” node, locate the target stored procedure, and right-click on it.
  10. Choose the “Dependencies” or “View Dependencies” option from the pop-up menu.
  11. In the dependency window, you can see a list of tables used in the stored procedure.

You can find the information of the tables used in the stored procedures using any method.

bannerAds