IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
we deleted records from a parent table with reorg - discard and WHEN condition (V12)
and hoped, the records in the dependent table were deleted, too, because there is a foreign key with ON DELETE CASCADE rule.
But DB2 do not delete the records in the dependent table. Dependent Table is in CHKP.
Do you have a hint to tell the reorg to do the deletion on dependent table ?
thanks and best regards