To set up ODBC to transfer data from a Microsoft Access database table to an iSeries file using Fetch-n-Fill:
- Create the iSeries file:
- Enter iSeries DDS specifications.
- Compile DDS to create the iSeries file.
- Create the Microsoft Access table within the database.
- In the ODBC 32-bit driver adminstrator, define the AS/400 DSN:
- Open the ODBC 32-bit Administrator.
- On the System DSN tab:
- Click Add to add new DSN entry.
- In the data source, choose Client Access ODBC Driver (32-bit).
- Click Finish.
- In Data source name, choose a meaningful name.
- Choose a meaningful description.
- In the System list, choose AS/400 System.
- On the Server tab, in Default libraries, enter a list of default iSeries libraries for this DSN entry.
- On the Translation tab, click Translate CCSID 65535.
- Click OK.
- In the ODBC 32-bit driver adminstrator, define the Microsoft Access DSN:
- Open the ODBC 32-bit Administrator.
- On the System DSN tab:
- Click Add to add new DSN entry.
- In the data source, choose Microsoft Access Drive (*.mdb).
- Click Finish.
- In Data source name, choose a meaningful name.
- Choose a meaningful description.
- In Database, click Select.
Select Database displays.
- Browse to the Microsoft Access database and highlight it.
- Click OK to select this database.
- Back in ODBC MicroSoft Access Setup, click OK.
- Set up the job in Fetch-n-Fill:
- Open Fetch-n-Fill.
- Create a new job in Fetch-n-Fill.
- Right-click New Job and click Properties.
- On the General tab:
- In Name, choose a meaningful name.
- For testing purposes, turn on:
- Show status while running.
- Count records before running.
- On the Origin tab:
- In DSN, choose the Microsoft Access DSN name from step 4.2.4.
- Leave User ID and Password blank.
- In Table, choose the table name from step 2.
- Click Get Field List to retrieve a list of Microsoft Access table fields.
- Highlight each field to select and then click Select Field(s).
Note: To select multiple fields at once, hold the CTRL key while highlighting fields.
- On the Destination tab:
- In DSN, choose the AS/400 DSN name from step 3.2.4.
- In User ID, enter a valid iSeries user name.
- In Password, enter the password for User ID.
- In Table, choose the iSeries file from step 1. Use the format:
[iSeries library name].[iSeries file name]
- Click Get Field List to retrieve a list of iSeries file fields.
- Using the same order as the fields you selected in the Origin tab, highlight each field to select and then click Select Field(s).
Note: To select multiple fields at once, hold the CTRL key while highlighting fields.
- Click OK to save the job information.
- Right-click the job and click Run to test the transfer.
Last Modified On:
No, open a new Support Case