The best way to get external data from iSeries 400 is by using ODBC driver. The Client Access ODBC driver is considered to be a very good option.
After you define the ODBC data source the iSeries data base is like any other SQL data base and you can connect to it from:
* Office (Word, Excel)
* Asp page
* ODBC compliant clients such as business object brio etc.
================================== MORE INFORMATION ON THIS TOPIC ==================================
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: tips, tutorials and more.
This was first published in March 2002