locate stored procedures in DB2 for IBM i Series
select *
from qsys2.sysprocs as p
where upper('ProcedureName') in (p.specific_name, p.routine_name, p.external_name)
order by specific_name
Written by Brian Rogers
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Sql
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#