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

2 Answers

It's complaining that no data member is in the table...

Either, there really isn't a data member, or perhaps the table is a Distributed Data Management (DDM) table.

From a 5250 command line, try the Display File Description (DSPFD) command.

You want to look at two sections, File description Header enter image description here

and on the second page of Data Base File Attributes, number of members enter image description here

Lastly, at the very bottom, there's a list of members enter image description here

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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.