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

Four Stars

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

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".

 

screenshot_1 (2).png

 

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

 

The AS400 version is V7R1.

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.