Syntax
The DELETE statement has the following formats:
Interactive and database procedure version:
[EXEC SQL] DELETE FROM [schema.]table_name [corr_name]
[WHERE search_condition];
Embedded non-cursor version:
[EXEC SQL] [REPEATED] DELETE FROM [schema.]table_name [corr_name]
[WHERE search_condition];
Embedded cursor version:
[EXEC SQL] DELETE FROM [schema.]table_name
WHERE CURRENT OF cursor_name;
table_name
Specifies the name of the table from which rows are to be deleted.
corr_name
Specifies a correlation name for the table for use in the search_condition.