HI! i keep having problems with datastage connecting to AS400
do you guys have any suggestions ?
even with metarecon i stuggle to connect is it a common problem ?
AS400
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Once I was involved with exposing DB2/400 tables on DB2 on an RS6000. One of the things we found was that, because every file on the AS400 is a table, it was vital to specify a filter on table names before connecting, otherwise the connection awaited the gathering of every single file name on the AS400 machine! (The ODBC configuration tool has 23 tabs!)