SQL0204 - *FIRST in *N type *MEM not found

Symptoms

When exporting data from AS/400 DB2 database the “SQL0204 - *FIRST in *N type *MEM not found” error is returned.

Cause

The object is not valid for the operation in the database. One possible reason is that the AS/400 file (table in terms of SQL) does not have any members.

Solution

Please, check, with some simple operation on this object, whether it's valid for the operation in the database. If the operation fails, then please contact your DBA for a help or check whether this table is actually used and required to be converted, probably you can exclude it from the conversion process.

SQLWays Migration Product Page Free Evaluation