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