The iFIX ODBC SQL task, WSQLODC.EXE, is responsible for:
- Executing the SQT blocks that trigger.
- 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.
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.
Refer to the following sections for information on:
