DSXchange

Hi,
We have a filebased system on AS400. Datastage is to be used as the ETL to extract those files. Could you please tell me how do we establish connection from DS side to read files in AS400?

Thanks.

Welcome aboard.

Use ODBC. Warning: EVERY file on AS/400 is considered by ODBC to be a "table" so make very sure to include a name filter in the ODBC data source configuration.

Thanks ray.