E1: XMLP: Is the Usage of Calculated Fields in SQL Queries Supported By the EnterpriseOne JDBC driver?
(Doc ID 843894.1)
Last updated on NOVEMBER 22, 2019
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
Most databases will allow calculations to be performed directly in SQL queries. For example:
However such query will not execute through Data Access Driver (DAD) but will execute as expected if ran using the native database driver. DAD returns an error indicating it cannot parse the query.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document