How to retain floating format values in a ECMA script used in a TIBCO IntegrationManager™ (IM) process?
Article ID: KB0090567
Updated On:
| Products | Versions |
|---|---|
| TIBCO IntegrationManager | - |
| Not Applicable | - |
Description
Description:
Using an ECMA script, the floating format value changes to exponential format.
Using an ECMA script, the floating format value changes to exponential format.
Issue/Introduction
How to retain floating format values in a ECMA script used in a TIBCO IntegrationManager™ (IM) process?
Resolution
In order to get the floating format value in a non-exponential format, set the following property to true.
Config.FESI.storeBigDecimalIntegerAsES: true
For example, consider two scenarios where this property can be used.
1). Using IM5.0.2, when using an ECMA script in IM 5.0.2 to do some simple number formatting where the data is a result of a select statement from an Oracle DECIMAL (15,2) column table, if the input value is 19979311.11, then the output produced is 1.997931111E7. Using this property the output is represented as 19979311.11 .
2). When calling a compare To or Equals function on a job slot inside an ECMA script, it causes an exception. Using this property resolved the problem.
Config.FESI.storeBigDecimalIntegerAsES: true
For example, consider two scenarios where this property can be used.
1). Using IM5.0.2, when using an ECMA script in IM 5.0.2 to do some simple number formatting where the data is a result of a select statement from an Oracle DECIMAL (15,2) column table, if the input value is 19979311.11, then the output produced is 1.997931111E7. Using this property the output is represented as 19979311.11 .
2). When calling a compare To or Equals function on a job slot inside an ECMA script, it causes an exception. Using this property resolved the problem.
Feedback
Yes
No
Powered by
