Configuring the SQL Task

The iFIX ODBC SQL task, WSQLODC.EXE, is responsible for:

• Executing the SQT blocks that trigger.

NOTE: When using the confirm tag for an SQT block that is triggered by an event, make sure that you define the security so that users do not have access to Mission Control to shut down the SQL task.

• Retrieving process data from the SQD blocks and inserting the data in the relational database.
• Selecting data from the relational database and writing the data back to the FIX® database.
• Backing up data in the event of a network failure (backup continues until the primary and secondary paths are full).
• Automatically restoring data to the relational database once network communications are re-established.

Refer to the following sections for information on:

• Modifying the Startup Options
• Using the SQL Task Dialog Box