Some times you need get the package name to do some tasks ….like for Ex: db2expln with -p option where -p represents package name
Well if that is the case this query might help you in getting the package name
The catalog tables you have to use are SYSCAT.PROCEDURES and SYSCAT.ROUTINENAME
select substr(procname,1,20) as procname , bname as packname from syscat.proceduers , syscat.routinedep where syscat.procedures.specificname = syscat.routinedep.routinename and syscat.procedures.procname = ‘ PROCEDURE_NAME ‘
Technorati Tags: bname,DB2,db2 explain,db2expln,package,Package name,routinedep,routinename,specific name,procedure,stored procedure
