tAs400Input

Anonymous — Wed, 05 Jun 2019 16:29:04 GMT

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

Re: tAs400Input

nfz11 — Thu, 06 Jun 2019 08:37:56 GMT

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-type-mem-not-found

This error means there are no members in the table.

topic Re: tAs400Input in Talend Studio

tAs400Input

Re: tAs400Input