Postgres JDBC driver is converting the numeric (Real) column data type to Integer for stored procedure.
Article ID: KB0079565
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions |
Description
If you are facing above mentioned behavior i.e. while pulling the data from the Postgres data source through Stored Procedure inside Spotfire Analyst, the columns having numeric data type are converted to Integer data type, then follow the resolution section.
Issue/Introduction
Postgres JDBC driver is converting the numeric (Real) column data type to Integer for stored procedure.
Environment
All Supported OS
Resolution
To stop this numeric data type conversion, follow the below steps:
1) For Spotfire 10.0 and older version, open Spotfire Analyst >> Tools Menu >> Information Designer.
For Spotfire 10.0 and above, open Spotfire Analyst >> Data Menu >> Information Designer.
2) Now, open the stored procedure and inside result columns section, uncheck the option-> "Include all result columns"
3) Add the output/resultant columns one by one as per your requirement.
1) For Spotfire 10.0 and older version, open Spotfire Analyst >> Tools Menu >> Information Designer.
For Spotfire 10.0 and above, open Spotfire Analyst >> Data Menu >> Information Designer.
2) Now, open the stored procedure and inside result columns section, uncheck the option-> "Include all result columns"
3) Add the output/resultant columns one by one as per your requirement.
Additional Information
Feedback
Yes
No
Powered by
