ODP - DB2 To Oracle - SQL Parsing Issue
(Doc ID 2462646.1)
Last updated on FEBRUARY 15, 2019
Applies to:
Oracle Database Provider for DRDA - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
The SQL uses a SUBSELECT resulting to a syntax error. Example below:
SELECT DEPTID, UPPER(DESCR), EFFDT, EFF_STATUS, CURRENT_DATE
FROM DRDAAS.SCOTT.EMP3 A
WHERE EFFDT =
(SELECT MAX(EFFDT)
FROM DRDAAS.SCOTT.EMP3 B
WHERE A.SETID = B.SETID
AND A.DEPTID = B.DEPTID
AND EFFDT <= CURRENT_DATE
)
AND SETID = 'FDIC1'
AND EFF_STATUS = 'A'
;
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -104, ERROR: ORA-00907: missing right parenthesis
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNprsqs SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 0 325 0 SQL DIAGNOSTIC INFORMATION
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |