Unable to retrieve all table schemas from an AS400/DB2 connection

[Anonymous]

Dear community,

I successfully established a connection via Talend Open Studio 7.0 to an AS400/DB2 database using JTOpen drivers which are recommended by IBM for such purposes. But when I try to retrieve schema information some table objects are not visible in Talend. I only can read tables with an AS400 attribut called "SQL Filetype: Table". Like you can see in screenshots below in german it's called "SQL Dateiart".

How can I read those objects where SQL Filetype is missing via TOS?

The AS400 version is V7R1.

[Anonymous]

Hello,

Are you able to choose the schema when create a connection for AS400? Is there any more error message in studio log?

Best regards

Sabrina