Rockwell Automation FactoryTalk View Site Edition Users Guide - Manual (Page 582)

F ACTORY T ALK V IEW S ITE E DITION U SER ’ S G UIDE
22–4
• •
•
•
•
 Tag table (optional) stores tag names in an index so that they can be referenced using
a 2- or 4-byte numeric field (rather than a 40-byte character field) in the float and
string tables.
How ODBC tables are named
The ODBC tables are created with the default names TagTable, FloatTable, and
StringTable. In the Data Log Models editor, you can modify these names before creating
the tables, or you can specify the names of different tables.
If you specify a backup path for an ODBC model, FactoryTalk View names the backup
log files as described on page 22-2.
Format for ODBC float and string tables
Floating-point and string data stored in ODBC format uses the following table: the float
table contains analog and digital tag data; the string table contains string tag data.
ODBC backup files are stored as binary files with the extension .obf. You cannot view the
contents of .obf files.
This column Contains SQL data type Length
DateAndTime The date and time the tag values were logged. SQL_DATETIME Driver
dependent
Millitm The millisecond time the tag values were logged. SQL_SMALLINT, or
SQL_INTEGER
4
TagIndex, or
TagName
The index number for the tag. The tag name that
corresponds to this number is listed in the tag
name table.
If the tag name table isn’t used, the tag name
appears in this column
SQL_SMALLINT, or
SQL_INTEGER
SQL_VARCHAR, or
SQL_CHAR
2 or
4
255
Val The analog or digital value of the tag. SQL_DOUBLE, or
SQL_INTEGER, or
SQL_SMALLINT 8, or
4, or
2
The string value of the tag. SQL_VARCHAR, or
SQL_CHAR 82