topic Re: Retreive tables with AS400 database in Talend Studio

Retreive tables with AS400 database

Anonymous — Sat, 16 Nov 2024 14:00:51 GMT

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

Re: Retreive tables with AS400 database

Anonymous — Tue, 31 Mar 2009 06:17:38 GMT

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

shong

Re: Retreive tables with AS400 database

Anonymous — Tue, 31 Mar 2009 06:41:05 GMT

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

Re: Retreive tables with AS400 database

Anonymous — Tue, 31 Mar 2009 13:35:51 GMT

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

Re: Retreive tables with AS400 database

Anonymous — Tue, 31 Mar 2009 14:55:49 GMT

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 ???

Re: Retreive tables with AS400 database

Anonymous — Tue, 31 Mar 2009 15:18:39 GMT

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

Re: Retreive tables with AS400 database

Anonymous — Tue, 31 Mar 2009 22:35:15 GMT

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

Re: Retreive tables with AS400 database

Anonymous — Wed, 01 Apr 2009 07:32:03 GMT

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

Re: Retreive tables with AS400 database

Anonymous — Wed, 01 Apr 2009 13:26:41 GMT

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

Re: Retreive tables with AS400 database

_AnonymousUser — Fri, 11 Feb 2011 23:24:32 GMT

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!