Reading AS400 Files

SrSoma · Post by **SrSoma** » Mon Jun 28, 2010 1:02 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 28, 2010 1:14 am

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.

SrSoma · Post by **SrSoma** » Wed Jun 30, 2010 2:35 am

Thanks ray.