Search code examples
ibm-midrange

Can't read table data in as400 error SQL0204

I'm trying to find data in an AS400 either through Excel with ODBC or through the free DBeaver software. My problem is that of many tables I can read the name and properties but I can't read the data because I get the error "SQL0204 * FIRST in * N" etc.

For example I can read the DTLEG00F table but not the CEGENDS table.

Why?

table DTLEG00F

table CEGENDS

Properties of CEGENDS

Solution

  • SQL0204 actually means table not found. In addition to above recommendation, please try:

    1. find library where this table exists;
    2. find out jobd associated with your login ID ;
    3. find out if library is part of jobd; also
    4. qualify it with library, e.g select * from Lib/tablename