Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    12

    Question Unanswered: Problem with relationship

    Hello everybody

    I have an application which get the information from a db2 database.
    Because I can't delete a datarecord in the application itself, I tried to delete it hardcore with SQL commands on db2.

    Now I have a problem with one record in a table. When I try to delete this record it tells me the message:
    SQL0532N A parent row cannot be deleted because the relationship "PM.AVNTDVER.AVNCDREV_DOC" restricts the deletion.

    I know from Oracle that there exists a system table which contains all the relationship between the tables. Is there also such a table in db2 or how can I find out which columns and which tables are affected by this relationship "PM.AVNTDVER.AVNCDREV_DOC"??

    Thanks for any help
    Raphael

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    In DB2, have a look at the SYSCAT.REFERENCES catalog view.

    http://tinyurl.com/29gw9x
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Oct 2006
    Posts
    12

    Thumbs up

    Quote Originally Posted by stolze
    In DB2, have a look at the SYSCAT.REFERENCES catalog view.

    http://tinyurl.com/29gw9x

    Thank you very much... that's exactly the tables I search many times

Posting Permissions

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