I use this query:

SELECT dep.bschema, dep.bname
FROM sysibm.sysdependencies dep, syscat.procedures proc
WHERE proc.procname = '$PROCNAME'
AND proc.procschema = '$PROCSCHEMA'
AND dep.dtype = 'F'
AND dep.dname = proc.specificname
AND dep.dschema = '$PROCSCHEMA'

I use it in a shell script, so substitue the proc name and schema accordingly.

If you have to use it on a version 7 database, change dep.dtype = 'F' to 'L'

HTH...



"Matt Emmerton" <memmerto@yahoo.com> wrote in message news:<U%xac.7618$JO6.2698@twister01.bloor.is.net.c able.rogers.com>...
> "hype" <hypehoopla@yahoo.com> wrote in message
> news:71c621b6.0403301353.31ee42@posting.google.com ...
> > Hi,
> > How do we find the package that is created when a stored procedure is
> > built ?
>
> The package name by default is the first 8 characters of the source code
> file that contains the stored procedure, unless you specify something
> different when you prep/bind.
>
> > If I want to rebind a package related to a stored procedure, what
> > command should I need to run ?
>
> DB2 REBIND <package_name>