Reading and Writing of SQL Data

The SQL Data block can read data from the iFIX process database or your relational database. After reading the data, the SQL Data block can write it to either database depending on the SQL command that executes.

A SELECT command with a Where clause instructs the block to read and write data to both databases. For values in the Where clause, the block reads from the process database and writes them to the relational database. However, for the values not in the Where clause, the block reads from the relational database and writes to the process database.