[pronerd]

I am trying to delete a row from a table in DB2. When I run the SQL below I get the error shown due to a table constraint. The problem I am running into is that I can not find a way to get DB2 to show me the constraint in question. So I do not know what other table or tables are related and blocking my delete.

SQL:

Expand|Select|Wrap|Line Numbers

1. SELECT *  
2. FROM sysadm.tb_ec3_bus_area 
3. WHERE b_area_nam ='Blah Blah'
4.  

Error :

Expand|Select|Wrap|Line Numbers

1. SQL0532N  A parent row cannot be deleted because the relationship "C2ECPYRF" 
2. restricts the deletion.  SQLSTATE=23504
3.  

When I tried to run describe against the table I get this error.

SQL:

Expand|Select|Wrap|Line Numbers

1. DESCRIBE table sysadm.b_area_nam
2.  

Error :

Expand|Select|Wrap|Line Numbers

1. DESCRIBE table sysadm.tb_ec_bus_area
2. DB21033E  The command is not valid for databases that reside on DRDA hosts.
3.  

When I looked up the table in the DB2 Control Center tool it does not show any constraints, or foreign keys.


Anyone know how I can get DB2 to show me what is constraining or restricting this table?

[docdiesel]

Hi,

try to use the command line tool db2look:

Expand|Select|Wrap|Line Numbers

1. db2look -a -e -d dbname -o outputfile.ddl

In outputfile.ddl you'll find a definition of all database objects and within there the table and its contraints. Another way is to habe a look at the system table sysibm.table_constraints:

Expand|Select|Wrap|Line Numbers

1. select  *
2. from    sysibm.table_constraints
3. where   CONSTRAINT_NAME='xxxxx'

Regards

Doc Diesel