SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

2-150

DELETE Statement

Considerations for DELETE

MXCI Examples of DELETE

C Examples of DELETE

COBOL Examples of DELETE

Publish/Subscribe Examples of DELETE

The DELETE statement is a DML statement that deletes a row or rows from a table or

an updatable view. Deleting rows from a view deletes the rows from the table on which

the view is based. DELETE does not remove a table or view, even if you delete the last

row in the table or view.

Starting with SQL/MX Release 3.2, self-referencing deletes are supported. With this

support, you can select the rows for delete from the target table in a subquery.

The three forms of the DELETE statement are:



Searched DELETE— Delete rows (the selection of which depends on a search

condition)



Positioned DELETE— Delete a single row that is determined by the cursor

position.



MULTI COMMIT DELETE (MCD)— Delete a large number of records in a series of

smaller independent transactions.

For the searched DELETE form, if there is no WHERE clause, all rows are deleted

from the table or view.

Embed