Verify successful data distribution

To verify that all result rows were successfully distributed to the corresponding target tags, check the state of the Boolean @rows_dropped variable. If the variable is TRUE , one or more tag updates failed. The interface stores the undelivered data, and you can write it to the RDBMS as follows:

SELECT timestamp AS PI_TIMESTAMP, name AS PI_TAGNAME
FROM table1
WHERE timestamp > GETDATE()-1
ORDER BY name, timestamp;

WHILE @ROWS_DROPPED
INSERT INTO table2 (name, timestamp, value)
VALUES (?,?,?) LOOP;

Note: The intent illustrated in the above statements is to INSERT the undelivered date into the RDBMS. Please, do not modify the example by substituting either UPDATE or DELETE.

The @rows_dropped variable is supported only for tag distribution.