My Oracle Support Banner

Updating AS400 Files Using DG4DRDA 11.2 or Generic Connectivity (DG4ODBC) Gives Error ORA-28500 And SQLCODE:-7008 (Doc ID 398417.1)

Last updated on MAY 11, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Oracle Database Gateway for DRDA - Version to [Release 11.2]
Information in this document applies to any platform.



Generic connectivity has been set up to DB2 on an AS400 using Isiris ODBC driver.

Selects work okay but inserts give the following error -


insert into as400.table@database_link ........
Error in Line1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_Execute: DB_ODBC_ENGINE (1645): ;
[IBM][iSeries Access ODBC-Driver][DB2 UDB]SQL7008 - ISRMUT in TABLE
Operation invalid. (SQL State: S1000; SQL Code: -7008)
ORA-02063: preceding 2 lines from DATABASE_LINK

This problem can also happen using Database Gateway for DRDA (DG4DRDA) 11.2.


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.