Package Name

AnilKale · #1 (**permalink**) 03-07-05, 01:26

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) ?

thanks.
Anil

n_i · #2 (**permalink**) 03-07-05, 10:09

Code:

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'";

sathish_T · #3 (**permalink**) 03-07-05, 10:45

Hi,

Good Day.

Please try this out :

SELECT * FROM SYSIBM.SYSPACKAGE , it will have the following fields.
LOCATION,COLLID,NAME etc....

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,
Sathish.T

I am very sorry .. above information is for DB2 on z\OS .. I do not know in case of DB2 On windows..

Regards,
Sathish.T

n_i · #4 (**permalink**) 03-09-05, 09:25

Quote:

Originally Posted by AnilKale

I don't see syscat.routines as one of the views.

Well, this works in v8. Try syscat.procedures then.

prithvi_raj · #5 (**permalink**) 03-09-05, 10:53

Select implementation from syscat.procedures where procname=xxxx

This will give you the package associated with the procedure...
is that what you want?

AnilKale · #6 (**permalink**) 03-10-05, 00:10

*******_raj,

yes, that's what I was looking for. thank you.
Anil

Internet Services

Web Development

Digital Marketing

Consumer Tech