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

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