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-326

Publish/Subscribe Examples of UPDATE

Suppose that these SQL/MP tables and index (and the metadata mappings) have been

created:

CREATE TABLE $db.dbtab.tab1 (a INT NOT NULL, b INT, c INT);

CREATE TABLE $db.dbtab.tab2 (a INT, b INT, c INT);

CREATE INDEX $db.dbtab.itab1 ON tab1(b, c);

CREATE SQLMP ALIAS cat.sch.tab1 $db.dbtab.tab1;

CREATE SQLMP ALIAS cat.sch.tab2 $db.dbtab.tab2;



This example shows the SET ON ROLLBACK clause:

SET SCHEMA cat.sch;

UPDATE tab1

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;