My Oracle Support Banner

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

Last updated on MAY 11, 2022

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



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

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