AS/400 ODBC connection problem.
Posted: Thu Jul 07, 2005 10:30 am
Hi All,
I've created an system DSN for an AS/400 using the ODBC. I have to import the ODBC table definitions. But when I try to access all (DEV2LIB, DEV3LIB, QGPL, MMDEVLIB) the AS/400 libraries defined in the ODBC connection, it just shows one (QGPL) AS/400 library. But in reality, there are four libraries in the ODBC connection. I don't understand why this is happening. I tried deleting the ODBC system DSN and created a new one, but in vain.
The same ODBC connection works fine with Microsoft Access. I'm able to see all the AS/400 libraries defined in the ODBC connection. But it is not working with Datastage, when I try to Import ODBC table definitions.
Is there anyway to tackle this issue? Does anybody know how and where Datastage stores the ODBC information.? Does it store in the project directory? If so, where?
Your suggestions and advice are tremendously appreciated,
Thanks in Advance,
Naveen.
I've created an system DSN for an AS/400 using the ODBC. I have to import the ODBC table definitions. But when I try to access all (DEV2LIB, DEV3LIB, QGPL, MMDEVLIB) the AS/400 libraries defined in the ODBC connection, it just shows one (QGPL) AS/400 library. But in reality, there are four libraries in the ODBC connection. I don't understand why this is happening. I tried deleting the ODBC system DSN and created a new one, but in vain.
The same ODBC connection works fine with Microsoft Access. I'm able to see all the AS/400 libraries defined in the ODBC connection. But it is not working with Datastage, when I try to Import ODBC table definitions.
Is there anyway to tackle this issue? Does anybody know how and where Datastage stores the ODBC information.? Does it store in the project directory? If so, where?
Your suggestions and advice are tremendously appreciated,
Thanks in Advance,
Naveen.