Connectivity between AS 400 and AIX

jayaraman · Post by **jayaraman** » Tue Aug 04, 2009 12:12 pm

Hi All,
My source files are in AS 400 system and the server is in AIX 5.3. Please let me what is the appropriate extraction strategy (stages and configurations) to be followed in this scenario.

Thanks in advance...

ray.wurlod · Post by **ray.wurlod** » Tue Aug 04, 2009 5:37 pm

Welcome aboard.

You can FTP the files to the AIX server, you could also access them as DB2/400 tables through ODBC or DB2 Connect.

jayaraman · Post by **jayaraman** » Wed Aug 05, 2009 3:04 am

Thanks a lot Ray for the valuable advise on the extraction strategy.
It would be very helpful if you can let me know if there are any particular configurations to be done for ODBC & FTP plug-ins. Because I tried to use ODBC stage but the error message was

"main_program: Fatal Error: Could not connect to datasource[DataDirect][ODBC lib] Data source name not found and no default driver specified
".

Are there any scripts to be run in the server to establish the connection?