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

16–12

RSView32 User’s Guide
If the ODBC database doesn’t support the SQL_TIMESTAMP data
type, then the data may be truncated. For example, the Oracle
®
ODBC driver does not support the SQL_TIMESTAMP type. Use
SQL_DATE instead to store both the date and time without
truncating the data in Oracle.
TagType The type of the tag in alarm: A for
analog, D for digital. SQL_VARCHAR
or SQL_CHAR 1
ThreshVal The threshold value. SQL_DOUBLE or
SQL_INTEGER or
SQL_SMALLINT 8 or
4 or
2
ThreshNum The threshold number. SQL_SMALLINT
or SQL_INTEGER 2 or
4
ThreshLabl The threshold label. SQL_VARCHAR
or SQL_CHAR 20
Severity The alarm severity. SQL_SMALLINT
or SQL_INTEGER 2 or
4
DstFlag The Daylight Savings Time (DST) flag,
where Y means DST is in effect and N
means DST is not in effect (for
RSView32 internal use only). SQL_VARCHAR
or SQL_CHAR 1
UserID The user that was logged in when the
alarm occurred. SQL_VARCHAR
or SQL_CHAR 20
AlarmType The number RSView32 assigns to the
transaction type. SQL_SMALLINT
or SQL_INTEGER 2 or
4
Dscription The message that is associated with the
transaction (alarm) type, the log
message for the alarm event, or the
alarm log remark. SQL_VARCHAR
or SQL_CHAR 132
UserStn For future use. SQL_VARCHAR
or SQL_CHAR 15
LoggingStn The name of the computer on which
the logging server is running. SQL_VARCHAR
or SQL_CHAR 15
This column Contains SQL Data Type Length