August 16, 2019

DSPPRC – Display Stored Procedure

Share this

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.

DSPPRC
DSPPRC – DSPROC

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

DSPPRC - Display Stored Procedure 1

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

DSPPRC - Display Stored Procedure 2

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

DSPPRC - Display Stored Procedure 3

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

DSPPRC - Display Stored Procedure 4
Drop a Stored Proc
DSPPRC - Display Stored Procedure 5

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:

DSPPRC - Display Stored Procedure 6

>