check existence of a stored procedure

[dataforums]

Does anyone know how to check if a DB2 stored Procedure exists in the database?

 

[sln007]

In the database, acces the "SYSCAT.PROCEDURES" table, to see Stored Procedures.

Here is an DB2 website for utility informational tables that can tell you much.

https://aurora.vcu.edu/db2help/db2s0/frame3.htm#rocatv

Steve N.
State of Ohio, MIS

 

[dataforums]

Thanks!. That helps.

 

[sln007]

dataforums,

Actually, the SQL for listing all SP's is in SYSIBM.SYSROUTINES

SELECT * FROM SYSIBM.SYSROUTINES
WHERE SCHEMA = 'schema-name'



Steve N.
State of Ohio, MIS