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 11.2.0.4 and laterInformation 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
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
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 |