Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC Error from HS Connection to AS400 (SQL State: S1000; SQL Code: -7008)

436562Jan 17 2005
I am trying to select two rows from a table on our AS400 system and just recently began receiving the following errors. I have also included a second error that I receive when querying an AS400 data dictionary file that is different from the first error seen below:


First Query Error:

select * from clmgen.abgacpp@as400 where rownum < 3
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - ABGACPP in CLMGEN not valid for operation.
(SQL State: S1000; SQL Code: -7008)
ORA-02063: preceding 2 lines from AS400

Second Query Error:

SELECT ''||COLUMN_NAME||' '||COLUMN_TEXT||',' FROM qsys2.syscolumns@AS400 WHERE SYSTEM_TABLE_SCHEMA = 'CLMGEN' and SYSTEM_TABLE_NAME = 'AABOREP'
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0913 - Row or object SYSCOLUMNS in QSYS2
type *FILE in use. (SQL State: S1000; SQL Code: -913)
ORA-02063: preceding 2 lines from AS400


Any assistance with these errors would be fantastic!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 14 2005
Added on Jan 17 2005
#heterogeneous-connectivity
0 comments
2,102 views