DELETE

The DELETE statement removes rows from a database table.

General format

EXEC SQL [AT Database]     DELETE Options [ WHERE {Search-Condition       } ]                          {CURRENT OF Cursor-Name }   END-EXEC

Syntax rules

1.	Options is passed to the driver without further checks. Refer to the database documentation for detailed syntax. Syntax errors, if any, are returned at runtime.

2.	Search-Condition is composed of predicates of various kinds, optionally combined using parentheses and logical operators. Its syntax is database dependent, therefore only Host Variables are handled and no further syntax checking is performed. Syntax errors, if any, are returned at runtime.

3.	Cursor-Name must be previously defined by a DECLARE statement.

General rules

1.	When Search-Condition is specified, only rows matching it are deleted.

2.	When Search-Condition is not specified, all rows are deleted.

3.	Database identifies the active connection that will execute the query and must be previously defined using a Format 4 DECLARE statement.

Examples

Delete 2 records by specific key

exec sql    delete from customers where  cust-code = 2 or cust-code = 4 end-exec