Results 1 to 6 of 6

Thread: Package Name

  1. #1
    Join Date
    Feb 2005
    Posts
    118

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

    thanks.
    Anil

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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'";

  3. #3
    Join Date
    Feb 2005
    Posts
    7
    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 ( egQL48225 ).

    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
    Last edited by sathish_T; 03-07-05 at 11:50.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.

  5. #5
    Join Date
    Apr 2004
    Posts
    36
    Select implementation from syscat.procedures where procname=xxxx


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

  6. #6
    Join Date
    Feb 2005
    Posts
    118
    prithvi_raj,

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •