var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Package Name
System: DB2 ver 7.2 on Windows
Which catalog view contains information that tells you package name associated with a stored procedure (build using stored procedure builder) ?
SELECT rtrim(bschema) || '.' || rtrim(bname)
FROM sysibm.sysdependencies p, syscat.routines r
WHERE r.routineschema='XXX' and r.routinename='ZZZ'
and p.dname = r.specificname and dtype = 'F' AND dschema ='XXX'";
Please try this out :
SELECT * FROM SYSIBM.SYSPACKAGE , it will have the following fields.
NAME filed will be your Package Name but will be SQLxxxx ( eg QL48225 ).
Go to DSN!10.SRCLIB.DATA(SQLxxxx) , view this member to get to which Stored Procedure this package is bound.
Please get back to me for any queries on this.
Thanks and Regards,
I am very sorry .. above information is for DB2 on z\OS .. I do not know in case of DB2 On windows..
Last edited by sathish_T; 03-07-05 at
Well, this works in v8. Try
Originally Posted by
Select implementation from syscat.procedures where procname=xxxx
This will give you the package associated with the procedure...
is that what you want?
yes, that's what I was looking for. thank you.