0 Replies Latest reply: Jan 17, 2005 2:22 PM by 436562 RSS

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

    436562
      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!