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