To export data for uploading to a mainframe

From the main menu, click 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 want to create.
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 specified.