Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    30

    Unanswered: How to see the package contents

    Hi All,

    Is there any way to see the contents of the packages. (i.e what all the statements package will execute).

    as I had to give the privileges to the db users, for particular packages.

    I appreciate your Quicker Response.

    Regards,
    Pushp

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Check out the view SYSCAT.STATEMENTS. It is described in the Catalog Views in Appendix D of the SQL Reference Vol 1.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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