Most of the times the data was sent to us in the form of flat files. The data is dumped and sent to us. In some cases were we need to connect to DB2 for look-ups as an instance then we used ODBC drivers to onnect to DB2 (or) DB2-UDB depending the situation and availability. Certainly DB2-UDB is better in terms of performance as you know the native rivers are always better than ODBC drivers. ‘iSeries Access ODBC Driver 9.00.02.02’ – ODBC drivers to connect to AS400/DB2.

Leave a Reply