DBA2187E Failed to delete selected row(s).

com.ibm.db.DataException: A database manager error occurred. : [IBM][CLI Driver][DB2/NT] SQL0532N A parent row cannot be deleted because the relationship "DB2SRV.A_VBHDR.FK_A_VBH_BCTBN" restricts the deletion. SQLSTATE=23504

HELPPPPP?
urgent
TQ

Type in

db2 "? sql0532n"

on your command line for help


or

download message reference manual from the db2 website www.ibm.com/db2/library

Cheers
Sathyaram

how to solve my problem? please help me....

Azrina, suppose you have 2 tables:
ACCOUNT (Parent Table)
ACCOUNT-TRANSACTION (Dependent Table, because every transaction must be associated to one account. To ensure this relation, an referential integrity rule without "cascade" option has been defined).
To delete one row from ACCOUNT table, all the dependents rows in ACCOUNT_TRANSACTION must be deleted first. With "cascade" option, when parent row is deleted, all dependents rows are automaticly deleted too.

I hoped this help you.

Regards, ALF.

Azrina,
You could try this.

drop the foreign key constraint first.
"ALTER TABLE <child table name> DROP FOREIGN KEY DB2SRV.A_VBHDR.FK_A_VBH_BCTBN"

recreate it with "on delete cascade"
"ALTER TABLE <child table name> ADD CONSTRAINT DB2SRV.A_VBHDR.FK_A_VBH_BCTBN FOREIGN KEY (column names) REFERENCES <parent table name> (column names) ON DELETE CASCADE"

Now, whenever the parent table data is deleted, the corresponding data in the child table would also be deleted.

Hope this helps.