PI tag configuation for a RDBMS

Setting Location2 to 0 (process only the first row) should do the work, as long as you can make sure the latest value always comes onto the 1st row.

Thank you Damian Nguyen​  what about if I want to select a specific colum(is that location 3 configuration?) . also can you please what location 4 and 5 are for.

I supposed what you meant by "Selecting specific column" is that you want to use a 'Group Distribution'. This means that your result table should look like [Time],[Value1],0,[Value2],0,etc. with 0s being separation columns. Have a look:

SELECT timestamp, temperature, 0, pressure, 0, level, 0

FROM table3

WHERE key1 LIKE 'Tank1' AND timestamp > ? ORDER BY timestamp ASC;

Location4 is for scan class and Location5 is for Exception Reporting (0 = enabled, 1 = disabled). Side note, you should also look into interface configurations like "Ignore Nulls" and "Read Before Overwrite", here's the user guide.

I supposed what you meant by "Selecting specific column" is that you want to use a 'Group Distribution'. This means that your result table should look like [Time],[Value1],0,[Value2],0,etc. with 0s being separation columns. Have a look:

SELECT timestamp, temperature, 0, pressure, 0, level, 0

FROM table3

WHERE key1 LIKE 'Tank1' AND timestamp > ? ORDER BY timestamp ASC;

Location4 is for scan class and Location5 is for Exception Reporting (0 = enabled, 1 = disabled). Side note, you should also look into interface configurations like "Ignore Nulls" and "Read Before Overwrite", here's the user guide.