Rockwell Automation RSBizWare Administration Guide - Manual (Page 303)

Application notes for FactoryTalk Transaction Manager Appendix D
An application error occurs upon configuration startup when you
attempt to connect to a Sybase back end. This error occurs because
the system environment variable for Sybase is missing or invalid.
Usually the ODBC driver installation sets the path and variables.
However, if the drivers were installed as a user account other than
administrator, the variables are not set.
The typical settings are:
Variable: SYBASE
Value: C:\Sybase
The Expression Editor operates on its internal Double data type that
does not cover the entire Int64 range. This requires imposing the
following limits on all incoming and outgoing Int64 parameters:
• For Int64 Signed: from -9007199254740991 to
9007199254740991.
• For Int64 Unsigned: from 0 to 9007199254740991.
The Expression Editor returns rounded results according to the
double data type behavior.
The Expression Editor rounds any arithmetical operation result if
the result exceeds the double type precision limit (including integer
and floating point numbers). The transaction passes but the passed
value is not exact. This behavior can lead to having invalid data
stored in the database.
Int64 Signed / Unsigned as an output parameter in a stored
procedure has the following limitations:
• For the Int64 Signed / Unsigned data point types in a
hexadecimal, octal or 0.x decimal format, the maximum value
is 2147483647.
Sybase values
Int64 Signed/Unsigned in the
Expression Editor
Int64 Signed/Unsigned as an
output parameter in a stored
procedure
Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 303