My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.