To import data downloaded from a mainframe

1. Click SQL for DB2 on the Tools menu; then click 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.
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.

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

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