Ispirer Website Ispirer Capabilities: DB2 Migration Free Trial

SQL Error Code: -204 SQL State: 42704 com.ibm.db2.jdbc.app.DB2 *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

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.


If you have any other questions, please contact us: support@ispirer.com