Extract info from the i5 into an Excel database file

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT DB2/400 and DB2 UDB When is the YES option for 'reuse deleted files' function the best choice? Monitoring members 'stuck' within a physical file on an EDI system Developing tables in a parent-child relationship in DB2 SQL server error message -321 Creating a host variable of the 'where in' statement in SQL Choose which column names are returned via ODBC when working with DB2 files Allow access to data from a stored procedure result set using COBOL or RPG Access path and an open data path differences Convert a numeric physical file to a character in SQL without leading zeros Inserting data from a CTE into a file in SQL

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

iSeries Access has an Excel Add-In that provides data transfer support. During iSeries Access installation process, install the following components:

Data Transfer Base Support and Data Transfer Excel Add-In (Under Data Access - Data Transfer)

Once installed, activate the iSeries Access Data Transfer feature add-in:

1. Open Excel worksheet

2. Select Add-Ins from the Tools pull-down menu.

3. Select the iSeries Access Data Transfer feature

To set up an SQL statement that returns data to the worksheet:

1. From the pull-down menu "Data", select "Transfer Data from iSeries"

2. From Transfer Request dialog window, select "Create New"

3. Specify the iSeries system name

4. On next dialog window, specify the library/file name

5. On next dialog window, press the "Properties" button

6. Select the "SQL" tab

7. Select the option "Process Select as native SQL" and Press OK

8. Press the "Data Options" button

9. From the "Change SQL Select Options" dialog window, enter your SQL statement and press OK

10. Press Next

11. If you want to save this definition so you can run it again later, specify a file name with the .DTF extension

12. Press Finish

The results of your query should be returned to the active worksheet.

Excel also has some data transfer features that allow you access iSeries data using ODBC drivers to access the system. If you want to play around with those, here's how to get started:

1. From the pull-down menu "Data", select "Import External Data" -> "New Database Query"