One Star

Retreive tables with AS400 database

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
9 REPLIES
Community Manager

Re: Retreive tables with AS400 database

Hello Didier
Which version of TOS do you use? Which OS?
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Retreive tables with AS400 database

Version: 3.0.3
Build id: r21383-20090126-2207
Didier
One Star

Re: Retreive tables with AS400 database

I have tried to use a SQL filter with:
SELECT * FROM QSYS2/SYSTABLES
or
SELECT * FROM QSYS2.SYSTABLES
No result!!
Strange!!
Didier
Seventeen Stars

Re: Retreive tables with AS400 database

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 !
Which OS?

... so ... which OS ???
One Star

Re: Retreive tables with AS400 database

Yes, my connection works.
With default option, I see a part of the tables but not all the tables.
Talend is installed on Windows XP.
Didier
Seventeen Stars

Re: Retreive tables with AS400 database

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 )
++
Employee

Re: Retreive tables with AS400 database

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
Seventeen Stars

Re: Retreive tables with AS400 database

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 !
++
One Star

Re: Retreive tables with AS400 database

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!