SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual523725-004
2-244
Publish/Subscribe Examples of UPDATE
SET b = b + 1
SET ON ROLLBACK a = a + 1
WHERE b < 10;
This example shows the SKIP CONFLICT access:
UPDATE tab1 SET a = a + 1
FOR SKIP CONFLICT ACCESS;