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 and later
Information in this document applies to any platform.


Using Database Gateway for DRDA (DG4DRDA) 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



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