Entering Your Own Table and Column Names

To enter your own table and column names:

  1. In Classic view, from the iFIX WorkSpace, click the System Configuration Utility button on the toolbar.

-Or-

In Ribbon view, on the Applications tab, in the System & Security group, click SCU.

  1. Click the Alarm button on the SCU toolbox.  
  2. Select the Alarm ODBC Service and the Enabled option.
  3. Click Modify.
  4. Click Configure.
  5. In the Database Configuration area, in the Table Name field, enter the name of the table to which you want to archive your alarms and messages.
  6. Select the Create Tables at Runtime If Not Found check box to create the table automatically when it cannot be found.
  7. From the Column Configuration area, select the alarm and message fields you want to archive.
    • Click Select All to select all the iFIX Field Names and populate the SQL Column Names automatically.
    • Click Clear All to deselect all the iFIX Field Names. The SQL Column Names remain populated.
    • Click Restore Defaults to use the FIXALARMS table to select the iFIX Field Names and the corresponding SQL Column Names.

TIP: If you select any of UserField iFIX Field Names, you can edit the database blocks in the User Fields section of the dialog box.

  1. In the Database Configuration area, click Create Table Now to create the table when you configure the service.
  2. Optionally, enter the column name that will store each selected field's information in the second column of the spreadsheet.

IMPORTANT: If you later change the table configuration through this dialog box, you must rename the table and press the Create Table Now to create it again. You cannot modify an existing table through this dialog box; you must create a new one to change the existing configuration.

  1. Click OK.

See Also