When you use the delete statement in the context of SQL, the statement removes a row from a database. You must have previously retrieved the record using a get or open statement with the forUpdate option.
DELETE FROM tableName
WHERE CURRENT OF cursor
You do not have the option of rewriting this statement
using the #sql directive.
Use the EGL execute statement to write a
custom
SQL DELETE statement.You cannot use a single EGL delete statement to remove rows from multiple SQL tables.