Restriction: This topic applies to Windows environments only.
- From the main menu, click
Run > Tools > Data Tools > SQL Option for DB2 > Client > SQL Wizard.
- Click
New on the
File menu.
- Click
Import.
- On the Import window, select the type of file from the
Format list.
- 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
- 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.
- Make any changes you require to the data types and other table structure information.
- Select
Create Table if you want to create a new table.
- Select
Replace Data if the table already exists and you want to replace its data with the imported data.
- Click
Browse to specify the table's location and name (or type the location and name in the
Table field and press
Enter).
- Click
Run on the
Import menu.
A new table is created or an existing table is updated with the imported data.