Page 1 of 1

AS400

Posted: Fri Sep 19, 2003 7:26 am
by sharad
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 ?

Posted: Fri Sep 19, 2003 8:55 pm
by ray.wurlod
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!)