ShowCase Query with Data Selection on a JDE Decimal Data field, when submitted via Deployment Portal produces incorrect results.

Troubleshooting

Problem

Serial #: 10137293 Error Message: Case Description: 1) Create a ShowCase Query against a J D Edwards data source and include a column that has decimal places defined via the Data Dictionary. 2) Add a data selection based on this column. 3) Run this Query in ShowCase Query client on the PC and see that the data selection works properly. 4) Save the query to the Repository. 5) Run this query via the Deployment Portal and see that the data selection does not work properly. Showcase Query version: 8.00.450 and Collaboration and Deployjment Services patch 4.0.4. Query Select statement I used is: SELECT DISTINCT WLOPST, WLOPSQ FROM JDWDTA91.F3112 F3112 WHERE WLOPSQ < 100.00 ORDER BY 2, 1 Running this query via the Query Client on a PC correctly returns rows where WLOPSQ are less than 100. Running this query via the Deployment Portal returns rows where WLOPSQ include values over 100.

[{"Product":{"code":"SS69YH","label":"IBM SPSS Collaboration and Deployment Services"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"4.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

91640

Was this topic helpful?

Document Information

More support for:
IBM SPSS Collaboration and Deployment Services

Software version:
4.0

Operating system(s):
IBM i

Document number:
426513

Modified date:
16 June 2018

UID

swg21487963

IBM Support

Tips