Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    30

    Unanswered: Object Dependencies

    DB2 Version :- 8.1 OS - Windows/Linux

    From which table i can retrive the object's dependencies in DB2 ? which should list the name of the objects and the order of other object dependenices with it.


    For example it I have created a table which contains foreign key relation with other table which references another table is said to be dependent on that table. Or Execution of one procedure might call another procedure, some table insertion/deletion/updation and hence dependent.

    How can I find out the list of dependent objects for a particular object.?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You need to look in all these SYSCAT views to get all the dependencies:

    CONSTDEP
    FUNCDEP
    INDEXDEP
    INDEXEXTENSIONDEP
    PACKAGEDEP
    ROUTINEDEP
    TABDEP
    TRIGDEP
    VIEWDEP
    XMLOBJECTRELDEP
    XMLOBJECTXMLDEP

    Refer to the SQL Reference Manual Vol 1 for what is exactly in each.

    HTH

    Andy

Posting Permissions

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