Restriction:This topic applies to Windows environments only.
From the main menu, click
Run > Tools > Data Tools > SQL Option for DB2 > Client > SQL Wizard.
In SQL Wizard, click
New > Export on the
File menu.
On the Export window, in the
Source Table Information group, click
Browse to specify the table's location and name (or type the location and name in the
Table Name field and press
Enter).
The names of all columns in the table appear in the
Included list.
Remove the names of any columns you don't want to export by clicking them in the list and clicking
<<.
Optionally, change the order of columns in the table by selecting a column name and clicking
Up or
Down to change its position in the list.
Optionally, type a condition (in SQL syntax) in the
Where Condition field to export a subset of rows in the table. For example: CUST_NO < 12850
In the
Target File Information group, 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 specify a location and name for the file you want to create (or type a location and name and press
Enter).
Click
Run on the
Export menu.
A new file is created containing the data you have specified.
