To import data from a PC application

  1. From the main menu, click Tools > SQL Option for DB2 > Client > SQL Wizard.
  2. Click New on the File menu.
  3. Click Import.
  4. On the Import window, select the type of file from the Format list.
  5. Change the settings as appropriate for the type of file you are importing:
    • Delimited (Free-Format) ASCII Files - fields are delimited by a fixed character, usually a comma or a tab
    • Columnar (Fixed-format) ASCII Files - fields and records have fixed lengths
  6. Click Browse to find the file you want to import (or type its location and name and press Enter).

    The data structure appears in the XDB Table Information group.

  7. Make any changes you require to the data types and other table structure information.
  8. Select Create Table if you want to create a new table.
  9. Select Replace Data if the table already exists and you want to replace its data with the imported data.
  10. Click Browse to specify the table's location and name (or type the location and name in the Table field and press Enter).
  11. Click Run on the Import menu.

    A new table is created or an existing table is updated with the imported data.

Parent topic: Import Files
Related information
Delimited (Free-Format) ASCII Files
Columnar (Fixed-format) ASCII Files