Example 1

Delete the row from table DEPTTBL where the value of DEPTNO equals D1.

EXEC SQL

DELETE FROM DEPTTBL
WHERE DEPTNO = 'D1'
END-EXEC