Using the ONLY Keyword (IDS)

If you use DELETE to remove rows of a supertable, rows from both the supertable and its subtables can be deleted. To delete rows from the supertable only, specify the ONLY keyword before the table name.

DELETE FROM ONLY(super_tab)
   WHERE name = "johnson"

You cannot specify the ONLY keyword if you plan to use the WHERE CURRENT OF clause to delete the current row of the active set of a cursor.