DSXchange

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...

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.

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?