Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
9 Replies
Anonymous
Not applicable
Author

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

shong
Anonymous
Not applicable
Author

Version: 3.0.3
Build id: r21383-20090126-2207
Didier
Anonymous
Not applicable
Author

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

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 ???
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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 )
++
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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 !
++
_AnonymousUser
Specialist III
Specialist III

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!