SQL Use in Database Blocks

The following database blocks can be used if you want to interface between your iFIX process database and a SQL relational database:

• SQL Data Block (SQD)
• SQL Trigger Block (SQT)

The SQD block acts as the actual interface, while the SQT block runs the SQL commands. When working with these block types, you should be aware of the following information:

• Reading and Writing Data of SQL Data
• Behavior of SQL Data Blocks While Off Scan
• Keywords Available for use in the SQL Data Block
• Direction of SQL Data Block
• SQL Trigger Block States
• SQL Trigger Blocks in Manual Mode