SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-173
Publish/Subscribe Examples of DELETE
•
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;