Errors Using Generic Connectivity to Connect to DB2 on AS400 - ORA-28500, SQL State:S1000, SQL Code: -7008
(Doc ID 295041.1)
Last updated on MAY 11, 2022
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.1 to 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Using generic connectivity and the IBM iSeries ODBC driver to select data from DB2 running on an AS400 gives the error -
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][unixODBC][IBM][iSeries Access ODBC
Driver][DB2 UDB]SQL7008 - <table-name> in <library-name> not valid for operation. (SQL State:S1000; SQL Code: -7008)
ORA-02063: preceding 2 lines from database_link_name
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