nag

Using the Default Table

While you can configure the Alarm ODBC Service with table and column names of your choosing, doing so can be time-consuming and error-prone. A simpler, faster, and easier way to specify a table for the service is to use the default table name, FIXALARMS. This table contains the following columns:

FIXALARMS Default Columns 

iFIX Field Name

Default SQL Column Name

Data Type (Size)

Native Date/Time In

ALM_NATIVETIMEIN

datetime

NOTE: On Oracle databases, the datatype is DATE.

Native Date/Time Last

ALM_NATIVETIMELAST

datetime

NOTE: On Oracle databases, the datatype is DATE.

Logical Node Name

ALM_LOGNODENAME

CHAR (10)

Tag Name

ALM_TAGNAME

CHAR (256)

NOTE: On Microsoft Access databases, the datatype is Memo.

Value

ALM_VALUE

CHAR (256)

NOTE: On Microsoft Access databases, the datatype is Memo.

Unit

ALM_UNIT

CHAR (13)

Message Type

ALM_MSGTYPE

CHAR (11)

Message Description

ALM_DESCR

CHAR (480)

NOTE: On Microsoft Access databases, the datatype is Memo.

Alarm Status

ALM_ALMSTATUS

CHAR (9)

NOTE: You can adjust the width of any column in the FIXALARMS table with your relational database software. Refer to your relational database documentation for more information.

When you use the default table name, the Alarm ODBC Service completes the Column Configuration spreadsheet for the columns listed in the previous table, thereby simplifying the setup. Similarly, when you create the table by clicking Create Table Now, the service simplifies its configuration again.

NOTE: If you want to change the fields that are in the default table, you must create a new table with a new name, and then transfer data from the existing table to the new table. You cannot modify the default table's fields by selecting or deselecting fields in the Column Configuration spreadsheet.