Directly importing an IXF file into a database table

You can also directly import the contents of an IXF file to a database table.

1. Select File > Import.
   The Import wizard opens.
2. Select Table and click Next.
   The Import table data from file page of the Import Table wizard opens.
3. Click Browse next to the File name field and enter the IXF file name.
4. Click Next.
   The Select results and destination information page of the Import Table wizard opens.
5. Select the database from the Database list.
6. Specify the table owner name in the Table owner field and the table name in the Table name field.
7. Click Next. The Set up acceleration options page opens.
   Restriction: The Set up acceleration options page opens only if the following conditions are met:

   • The database that you selected is a Db2 z/OS database that supports IDAA.
   • The Enable acceleration resource limit is enabled.
8. On the Set up acceleration options page, specify the destination where you want import the target table data.

   If you select the Database and accelerator or the Accelerator only option, select the accelerator that you want to use from the Accelerator list and use the Accelerator database field to specify the accelerator database where you want to save the data.

9. Click Next.
   The Set up save options page of the Import Table wizard opens.
10. Specify All - Result set only for the What data? option.
    Since you are retrieving data from a file rather than a query, all rows and columns will be imported.
11. Specify the Existing Data option.
    You use the following radio buttons to specify how the existing data will be saved to the database table:

    • Replace any existing data to replace any existing data in the database table with the contents of the IXF file.
    • Add to any existing data to append the IXF file contents to any data that already resides in the database table.
12. Click Finish.
    The Import Table wizard closes and the data contained in the IXF file is saved to the database table.