tAs400Input

[Anonymous]

Ciao All,

i am trying to figure out how to connect to an AS400 database to extract data.

I am able to create a metadata DB Connection to this AS400 DB, and so to retrieve schema for ALLof the table behind the DB. The problem is dthe following:

Building a very simple job (read from DB, writing into file):

- if i read from a table i am able to get output rows;

- if i read from one more table (The one which i should use) i get this error:

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

i am going crazy to understand why i am able (WITH THE SAME CONFIGURATION) to query a table and why in the other i am struggling with this issue.

thanks in advance

[nfz11]

Are you able to query that one table through a database client outside of Talend?

The error you are getting is from AS400 and not from Talend.

If you Google 'SQL0204 - *FIRST in *N type *MEM not found' you will find the explanation of the error.

https://wiki.ispirer.com/sqlways/troubleshooting-guide/db2/export-conversion/data/sql0204-first-in-n...

This error means there are no members in the table.