Syntax
The DELETE statement has the following formats:
Interactive version:
[EXEC SQL] DELETE FROM table_name
[WHERE search_condition];
Embedded non-cursor version:
[EXEC SQL] [REPEATED] DELETE FROM table_name
[WHERE search_condition];
Embedded cursor version:
[EXEC SQL] DELETE FROM table_name
WHERE CURRENT OF cursor_name;
table_name
Specifies the table for which the constraint is defined.