DG4DRDA Gives Error Arithmetic Overflow Or Other Arithmetic Exception Occurred {HY000,NativeErr = 802} (Doc ID 1956244.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Using Database Gateway for DRDA (DG4DRDA) 11.2.0.4 to select from DB2 on AS400 V7R1M0 gives the error -

Entered hgopoer at 2014/12/22-10:38:02
hgopoer, line 231: got native error 802 and sqlstate HY000; message follows...
[Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]Arithmetic overflow or other arithmetic exception occurred. Reason: (). {HY000,NativeErr = 802}
Exiting hgopoer, rc=0 at 2014/12/22-10:38:02
hgoftch, line 1068: calling SQLGetData got sqlstate HY000
 100 rows fetched
Exiting hgoftch, rc=28500 at 2014/12/22-10:38:02 with error ptr FILE:hgoftch.c LINE:1068 FUNCTION:hgoftch() ID:Row error while doing array fetch

 

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