I need to make an insert into an AS400 table, the same operation I've already done in a different job, but these time Talend cannot find the specified table in the database to retrieve it's schema.
The funny thing is that I'm able to select it from the Talend SQL Builder and from DBeaver.
Things I've already tried, that I found on the Talend Community:
- When retrieving the schema in the metadata, check connection buttom doesn't help.
- When retrieving the schema in the metadata, select all that appear and then next. The table doesn't appear in the next screen.
The database name is 'LHDADDBPD' and the table is 'EIPDPCV'.
I'm using Talend DI Open Studio v7.0.1.
Attached are some prints, showing that the table does not appear in the metadata retrieve schema but I can load it in the SQL Builder and, when I search by name, Talend doesn't find it.
