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 OCTOBER 17, 2019

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.

Checked for relevance on 29-May-2008


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.