beautypg.com

Example of short file names for wide .dbf format, The odbc storage format – Rockwell Automation 9301 Series RSView32 Users Guide User Manual

Page 208

background image

7–8

RSView32 User’s Guide

Example of short file names for wide .dbf

format

For wide .dbf file format, data log files are created in sets of two.

Example: Wide .dbf short log file name

The log file named 971028dw.dbf was created in the year 97, month
10, and day 28. The d indicates that this is the fourth file set created
that day. The w indicates that this file is in wide file format and may
contain both floating point and string tag data.

Example: Wide .dbf short log file set

If you were to look in the directory containing the data log files, you
would find two files with almost the same name.

971028dt.dbf

contains the tag name data

971028dw.dbf

contains the floating point data from analog and
digital tags and the string data from string tags

The ODBC storage format

Use the ODBC storage format to store your data using an ODBC data
source such as Microsoft Access or Microsoft SQL Server. The
ODBC format stores data in up to three tables, similar to narrow
format:

Tag table (optional)—stores tag names in an index so 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

Float table—stores analog and digital tag values