What is the process of importing data into a spreadsheet, and how do those ODBC drivers operate?
If you are importing into Microsoft Excel, you can create an SQL script that will import data directly from Universal DB2/400. In order to allow the scripting language (SQL - in this case) to make the CLI calls, you must provide information based on the ODBC driver you are using, the database you are connecting with, security information, the object you wish to operate against, and what you wish to do to that object. The good news is that most of this is done through selection screens.
If you are using Excel 2000, then select the menu option Data, Get External Data, New Database Query. You will be prompted for the Database (Based on the ODBC drivers installed on your system). Select the database that defines you AS/400 such as QDSN_AS400NAME. When you click OK, you will be connected to your DB2/400 Database. You may then select the file, fields and enter sorting, grouping and selection criteria. Once completed, you will be prompted to Return Data to Microsoft Excel. Click Finish. You will be prompted for the cell you wish to begin, and the import begins. Just remember that you can only import 65536 rows (records) of data.
This was first published in April 2001