Hello I have created a connection to an AS400 database. Now I want to retrieve my tables. When I select the 'Retrieve schema' option on my connection, I don't see all my tables like with 'iSeries Navigator' IBM tool. I use the same DB account on both tools. Any ideas??? Thanks Didier
hi dhonore
When you create your metadate dbConnection on As400 did you test succefully connection !?
On retrieving shema did you have this dialog "frame" (@see screenshoot) !?
I'm working every day on As400 (OS = linux :: TOS 3.0.3) without any kind of problems !
ok ,i'm ,ot a pro with As400 and working withmy own librairies and tables but Qsys are for description file for the system ...(logical file ?)
I know that they are "strongly" protected .. so perhaps some of them cannot be access !
(I'm going to ask more infos to the "pro of As400" at the team tomorrow )
++
For retriving the right tables on an AS 400 you have to specify the catalogs/library under the
"Additional Parameters" within the Talend connection tab.
Parameter libraries=<YourLib1>,<YourLib2>
For additional infos you can check the IBM side and search for JTOpen.
Regards
Martin
hi,
I see what you mean dhonore,
If i list tables of the QSYS(2) with Talend and compare to a list via Squirrel , all tables Q* doesn't appear in Talend (not its fault ).
cannot help more about this !
++
Hi, i want to add somes libraries in my AS400 connection like jdbc:as400://SrvOneAS400/; libraries=LIB1,LIB2,*LIBL when i check the connection, it's ok. But when i came in order to see my connection, i have this jdbc:as400://SrvOneAS400/LIB1; libraries=LIB1 my library list had changed! where is the problem ? what can i do to keep my libraries. I must have LIB1, LIB2, *LIBL because all my tables aren't only one table. thanks ouy very much for you help! sbernard. Sorry for my english!