ORA-02063 AND SQLCODE -301 WHEN DATABASE UPGRADED TO 10204 (Doc ID 970764.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for DB2 - Version 10.2.0.3 and later
IBM z/OS on System z
***Checked for relevance on 07-Jul-2011***


Symptoms

-- Problem Statement:
The following query fails after upgrade 10.2.0.4. This query executes a query through transparent gateway for DB2 and does an implicit comparison.

select NR_KREIS,
  JAHR,
  REGNR_VON,
  REGNR_BIS,
  REGNR_BIS - REGNR_VON AS DIFFERENCE
from RPT.VRPSNK@db2x_rpt
  where ((NR_KREIS='A1' AND JAHR='2008') OR (NR_KREIS='DG'
AND JAHR='2008')
  OR (NR_KREIS='HH' AND JAHR='2008') OR (NR_KREIS='MU'
AND JAHR='2008')
  OR (NR_KREIS='RR' AND JAHR='2008'))
  and REGNR_VON <= '2854120280' and REGNR_BIS >= '2854120280'
  order by DIFFERENCE asc;

The error message raised is :

SQLCODE = -301 AFTER UPGRADING DATABASE TO 10204


The definitions in the DB2 and Oracle have stayed the same

desc VRPSNK;
Name Null Type
------------------------------ -------- --------------------
U NOT NULL CHAR(2)
JAHR NOT NULL CHAR(4)
NR_KREIS NOT NULL CHAR(2)
REGNR_VON NOT NULL CHAR(10)
REGNR_BIS NOT NULL CHAR(10)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms