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

Anonymous — Sat, 14 Jul 2018 20:30:04 GMT

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.

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

Anonymous — Mon, 30 Jul 2018 08:39:00 GMT

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

topic Re: Unable to retrieve all table schemas from an AS400/DB2 connection in Talend Studio

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

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