Rockwell Automation 9301 Series RSView32 Users Guide - Manual (Page 579)

Sharing data with other Windows applications

16–17
Data log—ODBC format
ODBC format log data uses up to three tables. The illustrations show
ODBC tables that have been opened in Microsoft Query. For more
information, see “The ODBC storage format” on page 7-8.
Floating point and string data
Log tables for floating and string data are the same except one
contains analog and digital tag data and the other contains string tag
data.
This column Contains SQL Data Type Length
DateAndTime The date and time the tag values were
logged. SQL_TIMESTAMP 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 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 255