SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-117
Publish/Subscribe Examples of DELETE
•
This example shows the SET ON ROLLBACK clause in an embedded delete of a
SELECT statement:
SELECT * FROM
(DELETE FROM tab1 SET ON ROLLBACK a = a + 1) tab1;
•
This example shows SKIP CONFLICT ACCESS used with an embedded delete
statement accessing a table as a stream:
SELECT a FROM (DELETE FROM STREAM(tab1)
WHERE a = 1 FOR SKIP CONFLICT ACCESS) as tab1;