August 16

DSPPRC – Display Stored Procedure

DSPPRC will display all stored procedures on your IBM-i System

An IBM i SQL Stored Procedure is used to expose back-end business logic to the outside world. without rewriting the code again and/or providing the access to your database to Third party Vendors.


This will quickly display all the stored procs on your system:

We can interrogate the individual stored procedure details with a ‘5’ next to the *STOREDPROC in question:

We can even see the original SQL statement used to create that stored procedure using a ‘6’:

Did I mention that we can DROP that stored proc is its in error:

Drop a Stored Proc

Stored Procs with Errors

Any stored procs that point at procedures, or schemas, that do not exist will be highlighted as * NOT FOUND.

You should either fix or drop these stored procedures:



You may also like

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Get in touch

0 of 350